MSSQL – SQL-Server Uptime anzeigen

SET NOCOUNT ON
	DECLARE 
		@crdate DATETIME, 
		@day	int,
		@hr		int,
		@min	int,
		@sec	int
	SELECT	@crdate	= crdate 
	  FROM	sysdatabases 
	  WHERE NAME	= 'tempdb'
	SELECT	@day	= abs((DATEDIFF (day,    @crdate,GETDATE())))
	SELECT	@hr		= abs((DATEDIFF (HOUR,   @crdate,GETDATE()))-((DATEDIFF (day,    @crdate,GETDATE()))*24))
	SELECT	@min	= abs((DATEDIFF (MINUTE, @crdate,GETDATE()))-((DATEDIFF (HOUR,   @crdate,GETDATE()))*60))
	SELECT	@sec	= abs((DATEDIFF (SECOND, @crdate,GETDATE()))-((DATEDIFF (MINUTE, @crdate,GETDATE()))*60))
	select	CONVERT(VARCHAR(20),SERVERPROPERTY('SERVERNAME')) as UP_SRV_NAME,
			'Online for the past '+
				cast(@day as varchar(5)) + ' Tage '     +
				cast(@hr  as varchar(5)) + ' Stunden '  +
				cast(@min as varchar(5)) + ' Minuten '  +
				cast(@sec as varchar(5)) + ' Sekunden ' as UP_TXT,
			@crdate as UP_DATE,
			@day	as UP_DAYS,
			@hr		as UP_HH,
			@min	as UP_MIN,
			@sec	as UP_SEC