July 25, 2002 at 4:05 pm
Could any one tell me how we check what service pack has been applied to SQL Server. both for 6.5 and sql2000, from the client and server itself.
Thanks
Regards,
Naushi Hussain
Regards,
Naushi Hussain
July 25, 2002 at 4:23 pm
On server run select @@version and reference here:
http://www.sqlservercentral.com/faq/viewfaqanswer.asp?categoryid=2&faqid=123
Steve Jones
July 25, 2002 at 5:47 pm
Here is another list
2000.8.00.534 SQL Server 2000 SP2
2000.8.00.384 SQL Server 2000 SP1
2000.8.00.194.0 SQL Server 2000 "gold" release, no SP
7.00.623 SQL Server 7.0 "gold" release, no SP
7.00.677 MSDE in Office 2000, Office Developer
7.00.689 SQL Server 7.0 SP1 Beta
7.00.699 SQL Server 7.0 SP1
7.00.835 SQL Server 7.0 SP2 Beta
7.00.842 SQL Server 7.0 SP2
7.00.961 SQL Server 7.0 SP3
7.00.1063 SQL Server 7.0 SP4
6.50.201 SQL Server 6.5 "gold" release
6.50.213 SQL Server 6.5 with SP1
6.50.240 SQL Server 6.5 with SP2
6.50.252 SQL Server 6.5 with "bad" SP3. Do not use.
6.50.258 SQL Server 6.5 with SP3
6.50.259 SQL Server 6.5 on SBS only
6.50.281 SQL Server 6.5 with SP4
6.50.297 SQL Server 6.5 included in Site Server 3
6.50.339 SQL Server 6.5 "Y2K" Hot-fix
6.50.415 SQL Server 6.5 with "bad" SP5. Do not use.
6.50.416 SQL Server 6.5 with SP5a
6.50.479 SQL Server 6.5 with "post SP5a update"
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply