"Stored procedures that SQL Server supplies for use in system administration. These procedures are provided as shortcuts for retrieving information from the system tables, or mechanisms for accomplishing database administration and other tasks that involve updating system tables." (Karen Paulsell et al, "Sybase SQL Server: Performance and Tuning Guide", 1996)
"A SQL Server-supplied, precompiled collection of Transact-SQL statements. System stored procedures are provided as shortcuts for retrieving information from system tables or as mechanisms for accomplishing database administration and other tasks that involve updating system tables. The names of all system stored procedures begin with sp_. System stored procedures are located in the master database and are owned by the system administrator, but many of them can be run from any database. If a system stored procedure is executed in a database other than master, it operates on the system tables in the database from which it is executed. You can write stored procedures (called user-defined stored procedures), which can be executed from any database." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)
"A set of SQL Server-supplied stored procedures that can be used for actions such as retrieving information from the system catalog or performing administration tasks." (Anthony Sequeira & Brian Alderman, "The SQL Server 2000 Book", 2003)
"A type of stored procedure that supports all of the administrative tasks required to run a SQL Server system." (SQL Server 2012 Glossary, "Microsoft", 2012)
No comments:
Post a Comment