Tag: MS SQL Server

How to find dependencies of stored procedures in SQL Server

No Picture

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

No Picture

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 »