Tag «sp_sds stored procedure»

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 …