Chapter 21. Administrative Stored Procedures
Generally, management of many is the same as management of few. It is a matter of organization.
—Sun Tzu[1]
[1] Tzu, Sun. The Art of War. Cambridge, England: Oxford University Press, 1963. Page 90.
In this chapter we'll explore building administrative stored procedures. Although SQL Server comes with a large number of documented and undocumented stored procedures, there always seems to be a need for one more. That's what this chapter is about. It shows you some of the techniques you can use to build administrative code by taking you on a tour of several administrative routines that I've built. These routines demonstrate techniques that you can use in your own work and provide code that you may find ...
Get Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The 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.
