SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Database Engine
Technical Reference
Transact-SQL Reference
System Stored Procedures (Transact-SQL)
Security Stored Procedures (Transact-SQL)
sp_addapprole (Transact-SQL)
sp_addlogin (Transact-SQL)
sp_addremotelogin (Transact-SQL)
sp_addrole (Transact-SQL)
sp_addrolemember (Transact-SQL)
sp_addserver (Transact-SQL)
sp_addsrvrolemember (Transact-SQL)
sp_adduser (Transact-SQL)
sp_approlepassword (Transact-SQL)
sp_change_users_login (Transact-SQL)
sp_changedbowner (Transact-SQL)
sp_changeobjectowner (Transact-SQL)
sp_control_dbmasterkey_password (Transact-SQL)
sp_dbfixedrolepermission (Transact-SQL)
sp_defaultdb (Transact-SQL)
sp_defaultlanguage (Transact-SQL)
sp_denylogin (Transact-SQL)
sp_dropalias (Transact-SQL)
sp_dropapprole (Transact-SQL)
sp_droplogin (Transact-SQL)
sp_dropremotelogin (Transact-SQL)
sp_droprole (Transact-SQL)
sp_droprolemember (Transact-SQL)
sp_dropserver (Transact-SQL)
sp_dropsrvrolemember (Transact-SQL)
sp_dropuser (Transact-SQL)
sp_grantdbaccess (Transact-SQL)
sp_grantlogin (Transact-SQL)
sp_helpdbfixedrole (Transact-SQL)
sp_helplinkedsrvlogin (Transact-SQL)
sp_helplogins (Transact-SQL)
sp_helpntgroup (Transact-SQL)
sp_helpremotelogin (Transact-SQL)
sp_helprole (Transact-SQL)
sp_helprolemember (Transact-SQL)
sp_helprotect (Transact-SQL)
sp_helpsrvrole (Transact-SQL)
sp_helpsrvrolemember (Transact-SQL)
sp_helpuser (Transact-SQL)
sp_MShasdbaccess (Transact-SQL)
sp_password (Transact-SQL)
sp_remoteoption (Transact-SQL)
sp_revokelogin (Transact-SQL)
sp_revokedbaccess (Transact-SQL)
sp_setapprole (Transact-SQL)
sp_srvrolepermission (Transact-SQL)
sp_unsetapprole (Transact-SQL)
sp_validatelogins (Transact-SQL)
sp_xp_cmdshell_proxy_account (Transact-SQL)
Expand Minimize
0 out of 2 rated this helpful - Rate this topic

sp_xp_cmdshell_proxy_account (Transact-SQL)

SQL Server 2008

Creates a proxy credential for xp_cmdshell.

NoteNote

xp_cmdshell is disabled by default. To enable xp_cmdshell, see xp_cmdshell Option.

Topic link iconTransact-SQL Syntax Conventions

Copy 
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.

Copy 
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.

Copy 
EXEC sp_xp_cmdshell_proxy_account NULL;
GO
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.