got some cast errors with David's script.

try--

SET NOCOUNT ON

DECLARE @crdate DATETIME,

@days INT ,

@hr INT ,

@min-2 INT

SELECT @crdate=crdate FROM sysdatabases WHERE NAME='tempdb'

SET @min-2 = DATEDIFF (mi,@crdate,GETDATE())

SET @days= @min-2/1440

SET @hr = (@min/60) - (@days * 24)

SET @min-2= @min-2 - ( (@hr + (@days*24)) * 60)

PRINT 'SQL Server "' + CONVERT(VARCHAR(20),SERVERPROPERTY('SERVERNAME'))+'" is Online for the past '

+ CAST(@days AS VARCHAR(30))+ ' days & '

+ CAST(@hr AS VARCHAR(30))+' hours & '

+ CAST(@min AS VARCHAR(30))+' minutes'

IF NOT EXISTS (SELECT 1 FROM master.sys.sysprocesses WHERE program_name = N'SQLAgent - Generic Refresher')

BEGIN

PRINT 'SQL Server is running but SQL Server Agent NOT running'

END

ELSE

BEGIN

PRINT 'SQL Server and SQL Server Agent both are running'

END

thanks,

bc