2009. 3. 16. 10:37 DataBase/MSSQL
버전확인
MSSQL 2005
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
MSSQL 2000
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
MSSQL 7.0
SELECT @@VERSION
.....
http://support.microsoft.com/kb/321185/ko
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
| 릴리스 | Sqlservr.exe |
| RTM | 2005.90.1399 |
| SQL Server 2005 서비스 팩 1 | 2005.90.2047 |
| SQL Server 2005 서비스 팩 2 | 2005.90.3042 |
MSSQL 2000
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
| 릴리스 | Sqlservr.exe |
|---|---|
| RTM | 2000.80.194.0 |
| SQL Server 2000 SP1 | 2000.80.384.0 |
| SQL Server 2000 SP2 | 2000.80.534.0 |
| SQL Server 2000 SP3 | 2000.80.760.0 |
| SQL Server 2000 SP3a | 2000.80.760.0 |
| SQL Server 2000 SP4 | 2000.8.00.2039 |
MSSQL 7.0
SELECT @@VERSION
.....
http://support.microsoft.com/kb/321185/ko
반응형
