SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Chapter 11

Triggers and Stored Procedures

TOPICS COVERED IN THIS CHAPTER:

• Triggers Defined
• Using Triggers
• Creating Triggers
• Understanding Stored Procedures
• Creating Stored Procedures

Do not let the length of this chapter fool you. Triggers and stored procedures are two of the most valuable tools available to the DBA. Because this book is focused on the DBA's role and not the application developer's role, this chapter will focus on triggers and stored procedures from the perspective of administrative tasks instead of application development. Triggers are helpful because they can save the administrator from both wasted time and problems through ...