service pack

element19 · Feb 26, 2003

how do i find out what service pack is installed on our sql server 2000?

sunila7 · Feb 26, 2003

Hi,

Have a look at this FAQ by osjohnm

faq183-3159

Sunil

element19 · Feb 26, 2003

thank you so much for your help.

Kurniadi · Feb 26, 2003

Hi element19...

You can browse :

Kurniadi, Indonesia

TLGsoft · Feb 26, 2003

Run this in QA: SELECT @@version

if buildno is
780 then you have SP3
5xx then you have SP2
lower then you have SP1

manufcs · Feb 26, 2003

Hello,

This thread gives exact information about the SQL Server service pack installed.

Find SQL Server SP version
thread183-458253

Manu