2011. 8. 12. 14:32
SQL Server 버전 확인
2011. 8. 12. 14:32 in 4 Jobs/MS-SQL
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
Desktop Edition on Windows NT 5.1 (Build 2600: )
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
버전 번호 | 서비스 팩 |
---|---|
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) |