Objective: This script used to identify the collation, recovery model and status.
SELECT name,
DATABASEPROPERTYEX(name, 'Recovery'),
DATABASEPROPERTYEX(name, 'Status'),
DATABASEPROPERTYEX(name, 'collation'),
DATABASEPROPERTYEX(name, 'UserAccess'),
DATABASEPROPERTYEX(name, 'VERSION')
FROM master.dbo.sysdatabases
ORDER BY 1
Website:
http://www.mssqltips.com/tip.asp?tip=1033
