PRINT 'SQL Server was started: ' + CONVERT(char,@starttime)

-- determines when tempdb was created (done at startup)
DECLARE @starttime datetime
SET @starttime = (SELECT crdate FROM sysdatabases WHERE name = 'tempdb' )

-- determines when tempdb was created (done at startup)
DECLARE @starttime datetime
DECLARE @sql_version sysname
SET @sql_version = convert(sysname, (SELECT SERVERPROPERTY('Productversion')))

IF (@sql_version NOT LIKE '8.%')
BEGIN
	-- SQL Server 2005 and forward
	SET @starttime = (SELECT create_date FROM sys.databases WHERE name = 'tempdb')
	END
ELSE
BEGIN
	-- SQL Server 2000
	SET @starttime = (SELECT crdate FROM sysdatabases WHERE name = 'tempdb')
END

DECLARE @minutesSinceSQLStarted int

SELECT @minutesSinceSQLStarted = DATEDIFF(MINUTE,
    -- determines when tempdb was created (done at startup)  
    (SELECT crdate FROM master.dbo.sysdatabases WHERE name = 'tempdb'), GETDATE())

PRINT 'Time since SQL Server service was started: ' + 
    CONVERT(varchar(4), @minutesSinceSQLStarted / (60*24)) + ' days ' +  
    CONVERT(varchar(2), @minutesSinceSQLStarted % (60*24) / 60) + ' hours ' + 
    CONVERT(varchar(2), @minutesSinceSQLStarted % (60*24) % 60) + ' minutes.'