Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: What Version of SQL Server? (SQL)
Title: What Version of SQL Server? Language: SQL
Description: Used to determine version, product level and edition of SQL running on a box. Views: 752
Author: Michael Wood Date Added: 4/29/2008
Copy Code   
SELECT @@SERVERNAME, SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Usage 
Just run it. :)
Notes
Taken from KB article at http://support.microsoft.com/kb/321185.