[DB] mssql 2005 릴리즈 번호로 패치정보 확인하기

     

버전이 바뀌거나 ms-sql 2000, ms-sql 7  의 정보는 아래 싸이트서 확인하자
http://www.krell-software.com
ms-sql 2005 에서 업데이트 패치를 하게 되면, 어디까지 패치를 했는지 확인하기가 난감하다
그때 활용하면 좋은 내용!!

참고로 릴리즈 번호를 확인하는 방법은 아래 쿼리로 확인하자

select @@version

=====================================================================================

SQL Server 2005
How to obtain the latest service pack for SQL Server 2005
Main Releases
9.00.4035	Service Pack 3
9.00.3042	Service Pack 2
9.00.2047	Service Pack 1
9.00.1399	RTM
All Releases
9.00.4053	SP 3 + KB970892
9.00.4035	SP 3
9.00.3175	SP 2 + Q936305 / Q938825
9.00.3171	SP 2 + Q937745
9.00.3169	SP 2 + Q937033 / Q937041
9.00.3166	SP 2 + Q936185
9.00.3161	SP 2 + Q933724 / Q934706 / Q935356
9.00.3159	SP 2 + Q934459
9.00.3156	SP 2 + Q934226
9.00.3155	SP 2 + Q933549 / Q933766 / Q933808
9.00.3154	SP 2 + Q934106 / Q934109 / Q934188
9.00.3153	SP 2 + Q933564
9.00.3152	SP 2 + Q933097
9.00.3043	SP 2 + Q933508
9.00.3042	Service Pack 2
9.00.3033	SP 2 Dec CTP
9.00.3027	SP 2 Nov CTP
9.00.2245	SP 1 + Q933573
9.00.2234	SP 1 + Q937343
9.00.2233	SP 1 + Q933499 / Q937544 / Q937545
9.00.2232	SP 1 + Q937277
9.00.2229	SP 1 + Q935446
9.00.2227	SP 1 + Q933265 / Q934066
9.00.2226	SP 1 + Q933762 / Q934065
9.00.2224	SP 1 + Q932990 / Q933519
9.00.2223	SP 1 + Q932393
9.00.2219	SP 1 + Q931329 / Q932115
9.00.2218	SP 1 + Q931843
9.00.2216	SP 1 + Q931821
9.00.2215	SP 1 + Q923563 / Q931666
9.00.2214	SP 1 + Q929240 / Q930505 / Q930775
9.00.2211	SP 1 + Q930283 / Q930284
9.00.2209	SP 1 + Q929278
9.00.2208	SP 1 + Q929179 / Q929404
9.00.2207	SP 1 + Q928372 / Q928394 / Q928789
9.00.2206	SP 1 + Q928083 / Q928537 / Q928539
9.00.2202	SP 1 + Q927643
9.00.2201	SP 1 + Q927289
9.00.2198	SP 1 + Q924264 / Q924686 / Q924807 / Q924808 / Q925277 / Q925566 / Q926106 / Q926611 / Q926612 / Q926613 / Q926773
9.00.2196	SP 1 + Q926024 / Q926285 / Q926335
9.00.2195	SP 1 + Q926240
9.00.2194	SP 1 + Q925744
9.00.2192	SP 1 + Q924954 / Q925335
9.00.2191	SP 1 + Q916950 / Q925135
9.00.2190	SP 1 + Q925227
9.00.2189	SP 1 + Q925153
9.00.2187	SP 1 + Q923849 / Q924601
9.00.2183	SP 1 + Q924291
9.00.2181	SP 1 + Q922638 / Q923605 / Q923624
9.00.2176	SP 1 + Q922594 / Q923296
9.00.2175	SP 1 + Q919538 / Q919556 / Q919839 / Q920794 / Q921395 / Q921536 / Q922296 / Q922438 / Q922578 / Q922579
9.00.2174	SP 1 + Q922063
9.00.2167	SP 1 + Q920974 / Q921293 / Q921295
9.00.2164	SP 1 + Q918832 / Q918882 / Q919243 / Q919636 / Q919775 / Q919905 / Q919929 / Q920206 / Q920346 / Q920347 / Q921003
9.00.2156	SP 1 + Q917886 / Q919144 / Q919611
9.00.2153	SP 1 + Q918222
9.00.2047	Service Pack 1
9.00.2040	SP 1 Mar 2006 CTP
9.00.2029	SP 1 Beta
9.00.1558	Q926493
9.00.1554	Q926292
9.00.1551	Q922527 / Q922804
9.00.1550	Q917887 / Q921106
9.00.1547	Q918276
9.00.1545	Q917905 / Q919193
9.00.1541	Q917888 / Q917971
9.00.1539	Q917738
9.00.1538	Q917824
9.00.1537	Q917494 / Q917526
9.00.1536	Q917016
9.00.1534	Q916706 / Q916795
9.00.1533	Q916086
9.00.1532	Q916046
9.00.1531	Q915918
9.00.1528	Q915112 / Q915306 / Q915307 / Q915308 / Q915309
9.00.1519	Q913494
9.00.1518	Q911912 / Q912322 / Q912439 / Q912472 / Q912702 / Q913371 / Q913932 / Q913941
9.00.1514	Q912471
9.00.1503	Q911662
9.00.1502	Q915793
9.00.1500	Q910414 / Q910416 / Q910418 / Q910419
9.00.1406	Q932557
9.00.1399	RTM
9.00.1314	Sep 2005 CTP
9.00.1187	Jun 2005 CTP
9.00.1116	Apr 2005 CTP
9.00.1090	Mar 2005 CTP
9.00.981	Dec 2004 CTP
9.00.951	Oct 2004 CTP
9.00.852	Beta 2
9.00.836	Express Edition Tech Preview
9.00.608	Beta 1