Monday, August 2, 2010

SQL Server uptime

SQL 2005 Server uptime

select login_time
from sys.dm_exec_sessions
where session_id = 1


SQL 2008 Server uptime

SELECT sqlserver_start_time
FROM sys.dm_os_sys_info

No comments:

Post a Comment