CREATE procedure dba_uptime as
set nocount on
create table #output(outp nvarchar(1000))
insert #output(outp)
exec master.dbo.xp_cmdshell N'net statistics server'

declare @upsince datetime, @sqlupsince datetime, @noprocs int
set @noprocs = 8
set @upsince = 
(
	select	convert(datetime,replace(outp,'Statistics since ',''),103) as system_up_since
	from	#output
	where	outp like('Statistics since %')
)

drop table #output

set @sqlupsince =
(
	select	dateadd(s,-(32.0/@noprocs)*(cast(@@idle as float)+@@cpu_busy+@@io_busy)/1000.0,getdate())
)

select	@upsince as systemUpSince
	,@sqlupsince as sqlServerUpSince

go

exec dba_uptime
/*
systemUpSince           sqlServerUpSince
----------------------- -----------------------
2006-02-19 03:23:00.000 2006-03-29 08:35:26.803
*/

quote:

---

Originally posted by spirit1

hyperthreading counts as how many processors?

---

select SQL_Server_Start_Time = min(login_time) from sysprocesses

SQL_Server_Start_Time                                  
------------------------------------------------------ 
2006-04-07 17:03:23.493

(1 row(s) affected)

C:\>PSINFO \\MYCOMPUTER

PsInfo v1.73 - Local and remote system information viewer
Copyright (C) 2001-2005 Mark Russinovich
Sysinternals - www.sysinternals.com

System information for \\MYCOMPUTER:
Uptime:                    0 days 2 hours 50 minutes 58 seconds
Kernel version:            Microsoft Windows 2000, Uniprocessor Free
Product type:              Professional
Product version:           5.0
Service pack:              4
Kernel build number:       2195
Registered organization:
Registered owner:          Dr. Evil
Install date:              3/18/2002, 5:48:16 PM
Activation status:         Not applicable
IE version:                6.0000
System root:               C:\WINNT
Processors:                1
Processor speed:           930 MHz
Processor type:            Intel Pentium III
Physical memory:           256 MB
Video driver:              Radeon DDR

C:\>

C:\>psloglist -id 6005 -n 1

PsLoglist v2.62 - local and remote event log viewer
Copyright (C) 2000-2005 Mark Russinovich
Sysinternals - www.sysinternals.com

System log on \\MYCOMPUTER:
[5986] EventLog
   Type:     INFORMATION
   Computer: MYCOMPUTER
   Time:     4/7/2006 5:03:10 PM   ID:       6005
The Event log service was started.

set nocount on
drop table #t
create table #t (cmdout varchar(500) )
insert into #t
exec master.dbo.xp_cmdshell 'psloglist -id 6005 -n 1'

select 
	SYSTEM_UP_SINCE =
		convert(datetime,substring(cmdout,14,22)),
	SQL_SERVER_START_TIME
from 
	#t
	cross join
	(select SQL_SERVER_START_TIME = min(login_time) 
	from sysprocesses ) a
where
	cmdout like '%   Time: %' 

Results:

SYSTEM_UP_SINCE         SQL_SERVER_START_TIME
----------------------- -----------------------
2006-04-07 17:03:10.000 2006-04-07 17:03:23.493

quote:

---

Originally posted by Kristen

"should work for appx 68yrs uptime now"

Another compromise software development solution then, eh?

---