Determine Service Pack in 7.0?

[Lisa]

I need to determine which service pack we are running on our sql servers. I run SELECT @@VERSION and get it tells me that we are running 7.00.1020. I have a listing from google that tells me the value for each service pack, but my version doesn't match anything on the list.

Can you tell which service pack I am running based on the results of my query?

Thanks!

[Franco]

Lisa you have SQL 7.0 SP3 with a hot fix applied.
Please refer to
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q304851

HTH.
Franco

[Lisa]

Thanks Franco. Just what I needed.

Is there a master list somewhere that documents what all of the versions reflect? I found one for service packs, but it didn't reflect the hot fixes.


------------
Lisa at 4/15/2002 9:45:27 AM

I need to determine which service pack we are running on our sql servers. I run SELECT @@VERSION and get it tells me that we are running 7.00.1020. I have a listing from google that tells me the value for each service pack, but my version doesn't match anything on the list.

Can you tell which service pack I am running based on the results of my query?

Thanks!