Creates a proxy credential for xp_cmdshell.
.gif)
Transact-SQL Syntax Conventions
sp_xp_cmdshell_proxy_account [ NULL | { 'account_name' , 'password' } ]
- 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.
0 (success) or 1 (failure)
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.
Requires CONTROL SERVER permission.
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
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