October 1, 2004 at 6:35 am
Hello Everyone,
How can I verify which service is "installed" on a SQL Server 2000 client?
On the server we can verify the output of this query "select @@version", but how to get the same kind of information on a client?
Best regards,
Carl
October 4, 2004 at 8:00 am
This was removed by the editor as SPAM
October 7, 2004 at 12:44 pm
My question was suppose to be:
"How can I verify which service pack is "installed" on a SQL Server 2000 client?"
Instead of:
"How can I verify which service is "installed" on a SQL Server 2000 client?"
Sorry for the error.
Carl
October 18, 2004 at 10:29 am
I looked in the registry under:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\80\tools\ClientSetup\CurrentVersion
I would have tougth that:
If
8.00.194 Then SQL Server 2000 original release
If
8.00.384 -> SP1
Si
8.00.534 -> SP2
Si
8.00.760 -> SP3 ou SP3A
But this value did not changed.
But the new value CSDVersion was set to 8.00.761
Any idea?
Best regards,
Carl
October 18, 2004 at 12:21 pm
There's another discussion about this here http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=131031. That thread also contains a link to a Microsoft page with more detailed information about the build versions. Long and short of it is 8.00.761 indicates SP3a was installed. Hope this helps.
My hovercraft is full of eels.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply