How To Determine if SP3a installed on client PC?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fred - 29 Jun 2005 16:06 GMT

How can I tell (preferably by a version attribute on some DLL or EXE) that
Service Pack 3a has been installed on a client PC? KB articles such as
321185 do a great job of showing how to use SERVERPROPERTY to determine what
version the SERVER is running, but that's not my question. I need to know if
Service Pack 3a has been installed on a CLIENT, not the SERVER.

Reply to this Message

David Gugick - 29 Jun 2005 16:44 GMT

> How can I tell (preferably by a version attribute on some DLL or EXE)
> that Service Pack 3a has been installed on a client PC? KB articles
> such as 321185 do a great job of showing how to use SERVERPROPERTY to
> determine what version the SERVER is running, but that's not my
> question. I need to know if Service Pack 3a has been installed on a
> CLIENT, not the SERVER.

Run Query Analyzer and go to Help | About. If it's version 760 it's
SP3a.

Signature

David Gugick
Quest Software
www.imceda.com
www.quest.com

Reply to this Message

Fred - 29 Jun 2005 17:12 GMT

Is there a programmatic way to determing this? We use CA's SDO tool to push
client software and we need to figure out a way to programmatically test (a
DLL or EXE or registry key entry I assume) to see if SQL Server 2000 Service
Pack 3a is already deployed on a particular client PC.

> > How can I tell (preferably by a version attribute on some DLL or EXE)
> > that Service Pack 3a has been installed on a client PC? KB articles
[quoted text clipped - 5 lines]
> Run Query Analyzer and go to Help | About. If it's version 760 it's
> SP3a.

Reply to this Message

David Gugick - 29 Jun 2005 18:36 GMT

> Is there a programmatic way to determing this? We use CA's SDO tool
> to push client software and we need to figure out a way to
> programmatically test (a DLL or EXE or registry key entry I assume)
> to see if SQL Server 2000 Service Pack 3a is already deployed on a
> particular client PC.

Can your CA software check the file version of a file? If so, just check
the ISQLW.EXE file against the version you want (2000.80.760.0 for
SP3/SP3a)

Signature

David Gugick
Quest Software
www.imceda.com
www.quest.com

Reply to this Message

Star Fleet Admiral Q - 05 Jul 2005 02:22 GMT

SELECT @@VERSION

Signature

Star Fleet Admiral Q @ your Service!

http://www.google.com
Google is your "Friend"

> How can I tell (preferably by a version attribute on some DLL or EXE) that
> Service Pack 3a has been installed on a client PC? KB articles such as
[quoted text clipped - 3 lines]
> if
> Service Pack 3a has been installed on a CLIENT, not the SERVER.

Reply to this Message