jskfan
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
If that is not clear, than I am afraid I cannot help you any further.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I can see on Microsofot SQL Enterprise Manager Version 8.00.2039
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.