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.?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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.
gabesoSolution ArchitectCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.