Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The

sp_diffdb

This last example is kind of the grand finale (well, as close as we'll get) for this chapter. It makes use of a couple of the routines we looked at earlier in the chapter to provide a capability that is surprisingly absent from the SQL Server product itself—namely, the ability to check the differences between two databases. I probably get at least one e-mail message a week on this subject alone. People are always wanting to know how to determine the differences between two versions of a given database. Although there are third-party tools that provide this functionality, it tends to be a bit on the expensive side. I need this ability frequently myself, so I built a stored procedure that can check the schema of one database against that ...