SQL 2000

How would I check to see what service pac I am running on my sql 2000 server?

I have tried select @@version in the query.

It say’s version 2, but I think thats my os reading.

I am using server 2003 r2.

I loaded from a disc sp4 and it said successful, but, I am not see it.


Check this page http://support.microsoft.com/kb/321185

Thank you for the link.

It worked and told me what I needed.


you are welcomed [:D]