Monthly Archives: May 2013

T-SQL Stored Procedure to Report the Last Uptime of an Instance

/* Stored proc to report uptime of a sql server instance based on the initialization time of its tempdb. Version 2000+ */ use master go IF EXISTS (SELECT * FROM sysobjects WHERE name = ‘sp__uptime’ AND type = ‘P’) DROP … Continue reading

Posted in T-SQL Script | Tagged , | Leave a comment