Here is the Microsoft way to figure the version and servicepack levels
  Declare @V varchar(10), @sp varchar(5), @ed varchar(32), @nm varchar(32)
SELECT @v=convert(varchar(10),SERVERPROPERTY('productversion'))
,@sp=convert(varchar(5),SERVERPROPERTY ('productlevel'))
,@ed=convert(varchar(32),SERVERPROPERTY ('edition'))
,@nm=convert(varchar(32),@@servername)
Print 'SERVER:' + @nm
Print 'Version ' + @v
Print 'Level   ' + @sp
Print @ed  
My local 2008 server for example produces the following:
 SERVER:WEB-TESTMULE
Version 10.0.1049.                     <====Note the extra period! Level CTP Developer Edition  
 
 
 
 
 Posts
Posts
 
 
 
No comments:
Post a Comment
Be nice... it's the only internet we have.