Topic: SQL Server 2005 RSS feed for this category



sp_SDS Stored Procedure updated to work with SQL Server 2008 R2

19 December 2011

0 Comments

Derek Wade modified Richard Ding’s sp_SDS stored procedure to work with SQL Server 2008 R2. You can run the original stored procedure on SQL Server 2008 R2 however the report would be blank because there is version information in query for SQL Server 2008 R2 and this version information is expected. This version information has […]


Read this article…

Store Procedure SP_SDS – Custom Stored Procedure which generates Database and Log File size report

14 December 2011

0 Comments

SQL has quite a few store procedure one of them is sp_spaceused it’s a useful one to see the space used by the databases however it’s a bit basic. Now luckily there are some much extended versions that give much more detail and is useful for a number of reasons, one is because it gives […]


Read this article…

Stored Procedure to create a report on Database and Log File Size in SQL Server

14 December 2011

1 Comment

Knowing the size of a SQL Server database is one of the many DBA responsibilities that you can accomplish easily with the stored procedure sp_SDS. Not only will sp_SDS determine “SQL Database Space,” but it can also be used to monitor database growth, alert a DBA on data or log file growth, execute a transaction […]


Read this article…