tags:

views:

551

answers:

1

the title says it all...

+2  A: 

From MSDN: How to identify your SQL Server version and edition

-- SQL Server 2000/2005
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

-- SQL Server 6.5/7.0
SELECT @@VERSION
Sergio Acosta