Creates a proxy credential for xp_cmdshell.
xp_cmdshell is disabled by default. To enable xp_cmdshell, see xp_cmdshell Server Configuration Option.
Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database.
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