SQL Server 버전 확인

http://support.microsoft.com/kb/321185

2008
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

2005
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

2000
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

버전 7
SELECT @@VERSION

Microsoft SQL Server  7.00 - 7.00.623 (Intel X86)
        Nov 27 1998 22:20:07
        Copyright (c) 1988-1998 Microsoft Corporation

Desktop Edition on Windows NT 5.1 (Build 2600: )

버전 번호 서비스 팩
7.00.1063 SQL Server 7.0 서비스 팩 4(SP4)
7.00.961 SQL Server 7.0 서비스 팩 3(SP3)
7.00.842 SQL Server 7.0 서비스 팩 2(SP2)
7.00.699 SQL Server 7.0 서비스 팩 1(SP1)
7.00.623 SQL Server 7.0 RTM(Release To Manufacturing)

  

Read More