Summary
In this chapter, you learned about two important administrative tools: triggers and stored procedures. You started with triggers, first seeing how they work and then seeing the different uses they have for administrative automation. You learned how to actually create triggers. Then you moved on to stored procedures and learned the benefits they provide for the developer and the DBA. You learned how to create stored procedures and saw an example of how they can be used for administrative purposes as well.
Get SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond 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.
