United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2008 R2

Product Documentation

SQL Server 2008 R2 Books Online

Database Engine

Technical Reference

Transact-SQL Reference

System Stored Procedures (Transact-SQL)

General Extended Stored Procedures (Transact-SQL)

xp_cmdshell (Transact-SQL)

xp_deletemail (Transact-SQL)

xp_enumgroups (Transact-SQL)

xp_findnextmsg (Transact-SQL)

xp_grantlogin (Transact-SQL)

xp_logevent (Transact-SQL)

xp_loginconfig (Transact-SQL)

xp_logininfo (Transact-SQL)

xp_msver (Transact-SQL)

xp_readmail (Transact-SQL)

xp_revokelogin (Transact-SQL)

xp_sendmail (Transact-SQL)

xp_sprintf (Transact-SQL)

xp_sqlmaint (Transact-SQL)

xp_sscanf (Transact-SQL)

xp_startmail (Transact-SQL)

xp_stopmail (Transact-SQL)

Minimize

1 out of 1 rated this helpful - Rate this topic

General Extended Stored Procedures (Transact-SQL)

SQL Server 2008 R2

SQL Server supports the following system stored procedures that provide an interface from an instance of SQL Server to external programs for various maintenance activities.

xp_cmdshell	xp_logininfo
xp_enumgroups	xp_msver
xp_findnextmsg	xp_revokelogin
xp_grantlogin	xp_sprintf
xp_logevent	xp_sqlmaint
xp_loginconfig	xp_sscanf

Reference

System Stored Procedures (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.