Home » Computers » SQL » MS SQL Server Version

MS SQL Server Version

A select statement that returns the Version, Service Pack Level, and Edition information: (MS SQL 2000 and above)


[code]SELECT @@VERSION as ‘MS SQL’, SERVERPROPERTY(‘productversion’) as ‘Version’, SERVERPROPERTY (‘productlevel’) as ‘Level’, SERVERPROPERTY (‘edition’) as ‘Edition'[/code]


For MS SQL 7.0 and earlier use:


[code]SELECT @@VERSION[/code]


See Microsoft Knowledge Base KB321185 for more information.