February 5, 2010 at 3:25 pm
That is a nice find.
Thanks Max
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 6, 2010 at 11:48 am
Max Wei (2/5/2010)
The command 'net statistics server' seems not so reliable to report the uptime of a server.Out of curiousity, I ran it on on several servers, the results:
(1) my own XP laptop --showing correct time
(2) two Windows 2008 server: 2/6/2106
(3) another Windows 2008 server: 1/1/1980
Searched online and found that
net statistics workstation | find "Statistics since"
or
systeminfo | find "Boot Time"
would give the precise info.
yes i know. 'net statistics server' doesn't give you the right results,"workstation" is better.
the problem with systeminfo | find "Boot Time" that it doesn't exists in 2003.
February 6, 2010 at 11:51 am
CirquedeSQLeil (2/5/2010)
Your regional settings determine the date format. However, that is why there are standards that many use to format the datestamp in a common format for servers they administer that are in different regions.
it seems to be not accurate because all of my server use the Hebrew regional settings(and in the non-Unicode)and i get different results on server 2008 and server 2003
February 6, 2010 at 11:56 am
Mad-Dog (2/6/2010)
CirquedeSQLeil (2/5/2010)
Your regional settings determine the date format. However, that is why there are standards that many use to format the datestamp in a common format for servers they administer that are in different regions.it seems to be not accurate because all of my server use the Hebrew regional settings(and in the non-Unicode)and i get different results on server 2008 and server 2003
Your question was about the date format for SQL Server.
Netstat does not query sql server. It queries the operating system. Thus you would get different information for the different versions.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply