Wednesday, February 10, 2010

Reserved Resource Database in SQL Server 2005

TSQL Query to determine the version of Resource Database

SELECT SERVERPROPERTY('ResourceVersion')

TSQL Query to determine when the Resource Database was last backed up

SELECT SERVERPROPERTY('ResourceLastUpdateDateTime');

GO

No comments:

Post a Comment