Useful System Extended Stored Procedures
When you install SQL Server 7.5, Microsoft provides around 190 extended stored procedures. You or any other user on the system will never directly use most of these procedures. These extended stored procedures provide all types of functionality that aren't provided directly in the SQL Server engine. This functionality includes the ability to send, receive, and process email; add, read, and delete Registry keys; and provide direct access to the file system. Table 12.2 lists the most used system extended stored procedures.
| Stored Procedure | Description |
|---|---|
| xp_cmdshell | Executes a command string as an operating system command and returns any output data from ... |
Get Writing Stored Procedures for Microsoft SQL Server now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
