sql server new users: Does anyone how can i realize if some service pack is already installed in my mssqlserver? -- sql server new users

You're in the

sql server new users

group:

Does anyone how can i realize if some service pack is already installed in my mssqlserver?

Nosferatu
11/26/2004 1:11:44 PM

sql server new users:

Re: Does anyone how can i realize if some service pack is already installed in my mssqlserver?

Fredrik Wahlgren
11/26/2004 8:54:04 PM

[quoted text, click to view]

I think select @@VERSION will show what SP has been installed.

/ Fredrik

Re: Does anyone how can i realize if some service pack is already installed in my mssqlserver?

Mike Epprecht (SQL MVP)
11/27/2004 7:58:06 PM

Hi

SELECT @@Version

If it is less than 8.00.760, you are not on SP3a and you a very susceptible
to viruses (Slammer)

Regards
--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.

home · blog · groups

Questions? Comments? Contact the dn