April 5, 2003 at 12:00 am
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/gettingyourserverinformation.asp
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
April 21, 2003 at 8:47 am
Steve,
Have you ever used the serverproperty function to return version information?
Example:
select serverproperty('ProductVersion'), serverproperty('ProductLevel')
will return the version and SP number.
Diane
April 21, 2003 at 1:52 pm
I have not, though I know they are there. The single valued functions appear to come from the table.
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
April 22, 2003 at 2:16 pm
Excellent Insight Article.
.
April 23, 2003 at 9:15 am
Thanks. It was one of those little trivia things, but still it might help someone.
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
May 8, 2003 at 4:09 am
Enjoyed the article and also found dm's suggestion useful. Still finding my way around the expanse of SQL Server and tips like these really help me get to know it even better.
May 8, 2003 at 3:24 pm
Glad it helped.
BTW, an update: I spoke with someone on the internet who has done more testing and my inference that xp_msver was being called for @@Version is incorrect. There is actually a value stored in sqlsrvr.exe at a particular offset that has the version number. If you change this, you get a different version number (not recommended). In addition, unregistering and removing xp_msver still allows @@version to function.
so apparently there are more version numbers than I thought.
Steve Jones
http://qa.sqlservercentral.com/columnists/sjones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply