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)

  

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>