April 5, 2003 at 12:00 am
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/gettingyourserverinformation.asp
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
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
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
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply