What would you do if as a DBA someone asks you that Hey, i need to know how many stored procedures are their in this database?
1 . you are gonna count all of them? of course not.
2. use your dba magic and save the time.
So i was asked today we need to compare if the two Databases have same number of SPs.
This is what i did :
SELECT COUNT(*) as [Sp Count]