Link to home
Start Free TrialLog in
Avatar of jskfan
jskfanFlag for Cyprus

asked on

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

thanks
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

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".
SOLUTION
Avatar of m1tk4
m1tk4
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jskfan

ASKER

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.
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.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jskfan

ASKER

I can see on Microsofot SQL Enterprise Manager Version 8.00.2039
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial