Jul 162008

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

 Leave a Reply



You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>