Monday, March 1, 2010

Overview Of System and Extended Stored Procedures

In addition to the wide variety of system functions and global variables, Microsoft and Sybase supply system stored procedures and extended stored procedures, which provide ready-made programs and powerful extensions to T-SQL.

Here are some examples of system and extended stored procedures:

SP_Adduser
A system stored procedure that allows you to add a new user to a database

SP_Help
A system stored procedure that shows detailed information about a wide variety of database objects

SP_Lock
A system stored procedure that details the locking by user and system processes within the database server

SP_Who / SP_Who2
A system stored procedure that shows what user and system processes are active within the database server

xp_cmdshell
An extended stored procedure that allows you to execute any operating-system command-line executable, for example, use the xp_cmdshell extended stored procedure to ensure that a necessary file exists before performing a data load operation.
What is system stored procedures. what is database. how to use system stored procedures. sp_lock. database server. server administration. sql server 2012. sql server 2008 r2. in sql server 2008. in sql server 2005.

0 comments:

Post a Comment