/*******************************************************************\
*               Copyright © Pro-DBA.com 2006, all rights reserved   *
*                                                                   *
* Name     :    ServerUptime.sql                                    *
*                                                                   *
* Purpose  :    Shows last server start time and days elapsed       *
*                                                                   *
* Tested on:    SQL Server 7.0, SQL Server 2000, SQL Server 2005    *
*                                                                   *
\*******************************************************************/

DECLARE @serverstarttime datetime

SELECT @serverstarttime = login_time 
FROM master..sysprocesses WHERE spid = 1

PRINT ' Server Start  : ' + CONVERT(CHAR(25), @serverstarttime, 100)
PRINT ' Uptime (Days) : ' + CONVERT(CHAR(25), DATEDIFF(DAY, @serverstarttime, GETDATE()))
 (Days) : ' + CONVERT(CHAR(25), DATEDIFF(DAY, @serverstarttime, GETDATE()))