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