Stefan Haubolds weblog

Just so I don’t forget this very good article by Paul Randal. Read it now!

Top Tips for Effective SQL Server Database Maintenance

EXEC sp_MSforeachdb
'IF ''?'' NOT IN(''master'', ''model'', ''msdb'', ''tempdb'')
USE ? SELECT ''?'', SF.filename, SF.size FROM sys.sysfiles SF'

For SQL Server 2000 use:
EXEC sp_MSforeachdb
'IF ''?'' NOT IN(''master'', ''model'', ''msdb'', ''tempdb'')
USE ? SELECT ''?'', SF.filename, SF.size FROM sysfiles SF'

-- the old way
SELECT @@VERSION
-- better way, tells you the Service pack level, too
SELECT SERVERPROPERTY('productversion')
AS ProductVersion,
SERVERPROPERTY('productlevel')
AS ProductLevel,
SERVERPROPERTY('edition')
AS Edition
-- or
PRINT 'ProductVersion: '
+ CAST(SERVERPROPERTY('productversion')
AS VARCHAR(255))
PRINT 'ProductLevel  : '
+ CAST(SERVERPROPERTY ('productlevel')
AS VARCHAR(255))
PRINT 'Edition       : '
+ CAST(SERVERPROPERTY ('edition')
AS VARCHAR(255))