InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 18:50:25 GMT20http://www.sqlservercentral.com/Forums/Topic848914-2597-1.aspxHi ScottThanks for your improvement input - much appreciated :)Best regardsLars MikkelsenJN DataMon, 08 Nov 2010 01:06:40 GMTLars Søe Mikkelsenhttp://www.sqlservercentral.com/Forums/Topic848914-2597-1.aspxVery nice! You can shorten it up a bit though :-)[code="sql"]DECLARE @minutesSinceSQLStarted intSELECT @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.' [/code]Fri, 05 Nov 2010 15:54:15 GMTscott.pletcherhttp://www.sqlservercentral.com/Forums/Topic848914-2597-1.aspxHi Henrik,actually you don't need it, but I agree it would be better practice for SQL Server 2005 as well as SQL Server 2008 to use the sys.databases view which is available from SQL Server 2005 and forward.Do do this while still maintaining the compatibility with SQL Server 2000, you could replace this:[code]-- determines when tempdb was created (done at startup)DECLARE @starttime datetimeSET @starttime = (SELECT crdate FROM sysdatabases WHERE name = 'tempdb' )[/code]With this:[code]-- determines when tempdb was created (done at startup)DECLARE @starttime datetimeDECLARE @sql_version sysnameSET @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') ENDELSEBEGIN -- SQL Server 2000 SET @starttime = (SELECT crdate FROM sysdatabases WHERE name = 'tempdb')END[/code]The premises for this however is that you don't execute it on versions older than SQL Server 2000, but I hope you don't have any of them running anyway :-)Best regardsLars Søe MikkelsenJN Data Fri, 05 Nov 2010 05:43:22 GMTLars Søe Mikkelsenhttp://www.sqlservercentral.com/Forums/Topic848914-2597-1.aspxHej Lars,For SQL Server 2008 you need to change line 1 fromSELECT crdate FROM sysdatabases WHERE name = 'tempdb'to SELECT create_date FROM sys.databases WHERE name = 'tempdb'Med venlig hilsenHenrik Staun PoulsenStovi SoftwareFri, 05 Nov 2010 05:11:27 GMThenrik staun poulsenhttp://www.sqlservercentral.com/Forums/Topic848914-2597-1.aspxFantastic....Tue, 02 Mar 2010 01:39:56 GMTSatnam Singhhttp://www.sqlservercentral.com/Forums/Topic848914-2597-1.aspxLars,I didn't know it isn't available in SQL 2005. Nice to know for a project I'm working. Thanks for your solution!RegardsMarcoThu, 04 Feb 2010 02:48:45 GMTmchofmanhttp://www.sqlservercentral.com/Forums/Topic848914-2597-1.aspx[quote][b]mchofman (2/4/2010)[/b][hr]Lars,you can also retrieve the start time from this Dynamic Management ViewSELECT sqlserver_start_time FROM sys.dm_os_sys_info(Requires VIEW SERVER STATE permission on the server)Marco[/quote]Hi MarcoThat's correct for SQL Server 2008. The sqlserver_start_time in sys.dm_os_sys_info was added in SQL Server 2008 and wasn't there in SQL Server 2005.Using the tempdb works for all our current versions :) (yes, we still have SQL Server 2000)Kind regardsLarsThu, 04 Feb 2010 02:26:45 GMTLars Søe Mikkelsenhttp://www.sqlservercentral.com/Forums/Topic848914-2597-1.aspxLars,you can also retrieve the start time from this Dynamic Management ViewSELECT sqlserver_start_time FROM sys.dm_os_sys_info(Requires VIEW SERVER STATE permission on the server)MarcoThu, 04 Feb 2010 02:15:43 GMTmchofmanhttp://www.sqlservercentral.com/Forums/Topic848914-2597-1.aspxHi jks-591682To get the start time of the service, you could add this line:[code="sql"]PRINT 'SQL Server was started: ' + CONVERT(char,@starttime)[/code]Mon, 18 Jan 2010 01:32:25 GMTLars Søe Mikkelsenhttp://www.sqlservercentral.com/Forums/Topic848914-2597-1.aspxHi Lars. Very nice Scripts , if you could supply the startdate, ( SQL Server was started: Dec 15 2009 9:56AM Time since SQL Server service was started: 33 days 23 hours 17 minutes.) in the Output - It will fullfill it. Thanks :-)Mon, 18 Jan 2010 01:22:23 GMTjks-591682http://www.sqlservercentral.com/Forums/Topic848914-2597-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/GETDATE()/69319/">How long has passed since SQL Server service started?</A>[/B]Sun, 17 Jan 2010 15:28:35 GMTLars Søe Mikkelsen