How do I find out which Service Pak if any is installed in SQL

[DougP]

How do I find out which Service Pak if any is installed in SQL Server 7?

I know NT has service paks and SQL server has sp1. On the server where SQL is loaded is a folder called "SQL SP2"
I does contain Service pak 2 I can see in the readme file located there. But I'm not sure if it was installed or not. DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[foxdev]

In Query Analyzer, run the command

[tt]select @@version[/tt]

It will return a version and build number, such as:

[tab]7.00.842

I don't have the table of build numbers to service packs, but it can be found at the Microsoft site in the SQL Server download area.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[DougP]

thanks
DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive