System Stored Procedures System stored procedures are packaged with SQL Server. Many procedures are used to administer SQL Server, but some are utilities that can be profitablly used by developers. They are global, and can be called from any database application without their fully qualified name. (They are all owned by dbo.) . They are all stored in the Master database, and have the prefix sp_. This is a reason why it is considered unwise to name local stored procedures with the sp_ prefix. They can be read by viewing their properties in the Query Analyzer.
The system-stored procedures are grouped into these categories.
Category
Description
Active Directory Procedures
Used to register instances of SQL Server and SQL Server databases in Microsoft Windows 2000 Active Directory.
Catalog Procedures
Implements ODBC data dictionary functions and isolates ODBC applications from changes to underlying system tables.
Cursor Procedures
Implements cursor variable functionality.
Database Maintenance Plan Procedures
Used to set up core maintenance tasks necessary to ensure database performance....
To view and download this full PLR article, you must be logged in. Registration is completely free. Once you create your account, you will be able to browse, search & downlod from our PLR articles database of over "1,57,897+" on 1,000's of niches and 200+ categories without paying a penny. Click here to signup...
