Category «SQL Server 2000»

sp_SDS Stored Procedure updated to work with SQL Server 2008 R2

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 …

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

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 …

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

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 …