|
Home > Archive > MS SQL Server > March 2006 > Service Pack of client
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 |
Service Pack of client
|
|
|
| Hi,
Do we only install service packs for the Server?
Or we install them for client too. Is it possible that we have different
service packs in Client and Server? if yes, how can I check what service pack
do I have in client?
This command gives me the service pack of server. Right?
SELECT SERVERPROPERTY ('productlevel')
I can't find any command that shows me the service pack of client. Could you
please help me?
Thank you,
Rosie
| |
| Chris Wood 2006-03-30, 8:23 pm |
| Rosie,
Yes you should apply the SQL Service pack to the client tools. If you click
on Help/About in QA it will give you the build for the client tools.
Chris Wood
"Rosie" <Rosie@discussions.microsoft.com> wrote in message
news:1549B65A-FECF-49BB-8C7F- 874C453F552E@microso
ft.com...
> Hi,
> Do we only install service packs for the Server?
> Or we install them for client too. Is it possible that we have different
> service packs in Client and Server? if yes, how can I check what service
> pack
> do I have in client?
>
> This command gives me the service pack of server. Right?
> SELECT SERVERPROPERTY ('productlevel')
>
> I can't find any command that shows me the service pack of client. Could
> you
> please help me?
>
> Thank you,
>
> Rosie
>
| |
|
|
Help/About gives me the SQL Server version number. It doesn't say what
service pack.
SERVERPROPERTY ('productlevel') gives me the SP#. Do we have a similar
command for client?
Enterprise manager-->About Management Console is showing a service pack. Is
this the service pack of client?
Thank you,
Rozita
"Chris Wood" wrote:
> Rosie,
>
> Yes you should apply the SQL Service pack to the client tools. If you click
> on Help/About in QA it will give you the build for the client tools.
>
> Chris Wood
>
> "Rosie" <Rosie@discussions.microsoft.com> wrote in message
> news:1549B65A-FECF-49BB-8C7F- 874C453F552E@microso
ft.com...
>
>
>
| |
| Chris Wood 2006-03-31, 11:23 am |
| Rosie,
This will help http://www.aspfaq.com/sql2000Builds.asp
These are mostly the server builds but it does mention the service pack
builds and this will correspond with the QA Help/About. The Help/About in
SEM is all about MMC and Windows and nothing to do with SQL.
For you 194 is RTM
384 is SP1
534 is SP2
760 is SP3
2039 is SP4
Chris
"Rosie" <Rosie@discussions.microsoft.com> wrote in message
news:09DDB2D3-F22F-4A9B-83EC- B612555FAFC9@microso
ft.com...[color=darkred]
>
> Help/About gives me the SQL Server version number. It doesn't say what
> service pack.
> SERVERPROPERTY ('productlevel') gives me the SP#. Do we have a similar
> command for client?
>
> Enterprise manager-->About Management Console is showing a service pack.
> Is
> this the service pack of client?
>
> Thank you,
> Rozita
>
>
> "Chris Wood" wrote:
>
|
|
|
|
|