How to find dependencies of stored procedures in SQL Server
Manually reviewing hundreds of stored procedures is time consuming. The sp_depends system stored procedure doesn’t always give proper / correct results when the object creation order is different or following deferred name resolution. The output below for the stored procedure…
Read more »Determine free space for MS SQL Server databases
There isn’t a single command that gives you all the information. sp_helpdb This procedure will give you the total size of the database and associate files. It doesn’t tell you how much free space there is sp_spaceused This…
Read more »