Chapter 21: Interaction with the SQL Server Environment

Overview

This chapter focuses on the ways you can use system and extended stored procedures to interact with the SQL Server environment. It also discusses the ways user-defined stored procedures can help you leverage the existing functionality of elements within the SQL Server environment.

By the end of this chapter, you will be able to do the following:

• Run programs and operating system commands from the command shell

• Use OLE Automation/COM objects in Transact-SQL

• Run IS packages

• Execute DTS packages

• Implement looping in DTS packages

• Manage jobs in Job Scheduler

• Perform administration tasks with stored procedures

• Read and write Registry entries

• Use the e-mail capabilities of SQL Server to notify users of events on the server

• Use the e-mail capabilities of SQL Server to send query results

• Expose stored procedures as web services