|
Home > Archive > MS SQL Server > October 2006 > What SP is installed on server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
What SP is installed on server
|
|
| moondaddy 2006-10-24, 6:30 pm |
| How do I determin which service pack is installed on sql server?
--
moondaddy@noemail.noemail
| |
| Warren Brunk 2006-10-24, 6:30 pm |
| SELECT SERVERPROPERTY('prod
uctversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')
here is the best place to find what version numbers mean...
http://support.microsoft.com/kb/321185/
--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"moondaddy" <moondaddy@noemail.noemail> wrote in message
news:%23NKVCxT3GHA.4024@TK2MSFTNGP03.phx.gbl...
> How do I determin which service pack is installed on sql server?
>
> --
> moondaddy@noemail.noemail
>
| |
| Charles Wang[MSFT] 2006-10-24, 6:30 pm |
| Generally, "select @@version" is clear.
Please don't hesitate to let me know if you have any other questions or
concerns.
Sincerely,
Charles Wang
Microsoft Online Community Partner
| |
| Charles Wang[MSFT] 2006-10-24, 6:31 pm |
| Hi,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support
====================
====================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
====================
====================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
====================
====================
==============
|
|
|
|
|