Home Forums Article Discussions Article Discussions by Author Discuss content posted by Lars Søe Mikkelsen How long has passed since SQL Server service started? RE: How long has passed since SQL Server service started?
Henrik Staun Poulsen
SSCertifiable
Points: 6551
More actions
November 5, 2010 at 5:11 am
#1247046
Hej Lars,
For SQL Server 2008 you need to change line 1
from
SELECT crdate FROM sysdatabases WHERE name = 'tempdb'
to
SELECT create_date FROM sys.databases WHERE name = 'tempdb'
Med venlig hilsen
Stovi Software