Jaa


sp_xp_cmdshell_proxy_account (Transact-SQL)

Creates a proxy credential for xp_cmdshell.

Topic link iconTransact-SQL Syntax Conventions

Syntax

sp_xp_cmdshell_proxy_account [ NULL | { 'account_name' , 'password' } ]

Arguments

  • NULL
    Specifies that the proxy credential should be deleted.
  • account_name
    Specifies a Windows login that will be the proxy.
  • password
    Specifies the password of the Windows account.

Return Code Values

0 (success) or 1 (failure)

Remarks

The proxy credential will be called ##xp_cmdshell_proxy_account##.

When it is executed using the NULL option, sp_xp_cmdshell_proxy_account deletes the proxy credential.

Permissions

Requires CONTROL SERVER permission.

Examples

A. Creating the proxy credential

The following example shows how to create a proxy credential for a Windows account called ADVWKS\Max04 with password ds35efg##65.

EXEC sp_xp_cmdshell_proxy_account 'ADVWKS\Max04', 'ds35efg##65";
GO

B. Dropping the proxy credential

The following example removes the proxy credential from the credential store.

EXEC sp_xp_cmdshell_proxy_account NULL;
GO

See Also

Reference

xp_cmdshell (Transact-SQL)
CREATE CREDENTIAL (Transact-SQL)
sys.credentials (Transact-SQL)
System Stored Procedures (Transact-SQL)
Security Stored Procedures (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance