Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1469
  • Last Modified:

CHeck SQL service pack

in a server that doesn't have MSSQLSERVER service running in it, but it has EM,query analyser etc... I would like to know what service pack installed in it. i just run the SP4 and want to make sure it's installed.

I tried to use query analyser so that I can run  Select @@version , but it doesn't open the query analyser this makes sense since there is no MSSQLSERVER.

I also looked on add/remove program and there is no sign about SQL service pack.

can someone tell me how to find if the SQL SP4 is installed.?

3 Solutions
Anthony PerkinsCommented:
Select @@VERSION will give you the server version.  Since you want to see the version for the client components you do it the old fashioned way.  For example in SQL Query Analyzer you go to the Help menu and About ... of it reads version 8.00.2039 you get an "A".
Open Enterprise Manager, right click the Server, click Properties
Under "General" tab "Product Version" would have the service pack in brackets (mine shows as 8.00.760(SP3) for example).
jskfanAuthor Commented:
I said the server doesn't have the MSSQLSERVER service, so I can't connect to it eventhough it's local, but the SP4 was installed with no error. the only thing I need is how to find out a way to check if it's installed.

if you don't have MSSQLSERVER service on the server you can' connect to it neither remotely nor localy. unless if you connect to a different SQL server and from there you run a query against the server that doesn't have the MSSQLSERVER service on it.
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Anthony PerkinsCommented:
I understand that.  Again, if you need to check the version of the SQL components (**not ** the server) all you have to do is check the About screen in SQL Query Analyzer.

If that is not clear, than I am afraid I cannot help you any further.
Microsoft applications have a help option on the menu bar and one of the items on the help menu is an 'about' option that displays general information about the application including the version number.

What 'acperkins' is saying to you is that if you look at the about box and you see version '8.00.2039' then it means that MS SQL Server client tools SP4 is installed.
jskfanAuthor Commented:
I can see on Microsofot SQL Enterprise Manager Version 8.00.2039
Anthony PerkinsCommented:
Great!  That means you have the clinet components updated with SP4

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now