• Very nice! You can shorten it up a bit though 🙂

    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.'

    Scott Pletcher, SQL Server MVP 2008-2010