xp_msver
I looked up Books Online for information about @@version yesterday, and was pleasantly surprised to discover that @@version simply calls a stored procedure named xp_msver, which returns all the different parts of @@version, but in a result set. It doesn’t really give you much more information than what @@version provides, but something might come in handy, particularly if you wanted to pull out a single part of the @@version string programmatically.
Values include: Product Name, ProductVersion, Language, Platform, Comments, CompanyName, FileDescription, FileVersion, InternalName, LegalCopyright, LegalTrademarks, OriginalFilename, PrivateBuild, SpecialBuild, WindowsVersion, ProcessorCount, ProcessorActiveMask, ProcessorType, PhysicalMemory, Product ID
July 16, 2008 8:59 am 
Subscribe