First stab at a database inventory script

Compatible with sql server 2k5:

USE master
CREATE TABLE #tempresults

[name] sysname,
db_size NVARCHAR(13),
[owner] sysname,
[dbid] smallint,
created NVARCHAR(11),
[status] NVARCHAR(600),
compatibility_level tinyint

INSERT INTO #tempresults
EXEC sp_helpdb
SELECT, tr.db_size, db.compatibility_level,is_auto_shrink_on, state_desc, recovery_model_desc, page_verify_option_desc

FROM sys.databases db
JOIN #tempresults tr

WHERE dbid >4 --This clause will exclude system DBs,master, model, msdb, and tempdb
DROP TABLE #tempresults

This entry was posted in SQL Server, T-SQL. Bookmark the permalink.