RE: Identifying the SP3 and SP3a
- From: "Mike Epprecht (SQL MVP)" <mike@xxxxxxxxxxxx>
- Date: Tue, 19 Jul 2005 09:02:04 -0700
Hi
Not that I know of. This discussion has come up a few times already and the
file way is the way to do it.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Harshal" wrote:
> I want to identify the machines installed with SP3 and SP3a, the readme doc
> of SP3a says the above can be done by looking at the version of Ssnetlib.dll
> in the default folder of SQL installation. But at present I don't have the
> liberty to do so.
> Is there any other reliable way to figure out the presently installed
> service pack on the machine, a way safely identify machines with SP3 from
> machines with SP3a.
> I have tried using the following command but the result is same for SP3 and
> SP3a
>
> SELECT 'SQL Server '
>
> + CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '
>
> + CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('
>
> + CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'
>
> Machine with SP3
>
> SQL Server 8.00.760 - SP3 (Standard Edition)
>
> Machine with SP3a
>
> SQL Server 8.00.760 - SP3 (Standard Edition)
>
> Why is that Microsoft hasn't made the appropriate changes to reflect the
> right service pack installed on the machine, is SP3a special?
>
>
> Thanking You in Anticipation
> Harshal
.
- References:
- Identifying the SP3 and SP3a
- From: Harshal
- Identifying the SP3 and SP3a
- Prev by Date: Re: SQL Mail configuration
- Next by Date: Re: SQL2000 disabled after installing Norton Antivirus 2005
- Previous by thread: Identifying the SP3 and SP3a
- Index(es):
Relevant Pages
|
