Avatar of me_mcneely
me_mcneely

asked on 

SQL Server 200 service pack3/4 when installed

How do I find when a service pack was installed for SQL server 2000?
Microsoft Legacy OSMicrosoft Server OSWindows 2000

Avatar of undefined
Last Comment
me_mcneely
ASKER CERTIFIED SOLUTION
Avatar of Dean Chafee
Dean Chafee
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Dean Chafee
Dean Chafee
Flag of United States of America image

Sorry... answered too fast.  You want to know *when*.
The easy way that I usually check is that there will be a folder created called C:\sqlsp4    (or something similar). Check the create date of the folder, assuming it was extracted and installed on the same day.
SP3... not sure. I will research.
fs
SOLUTION
Avatar of Dean Chafee
Dean Chafee
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of me_mcneely
me_mcneely

ASKER

Thank you, fs. I did not find either folder on the production server, but I found sp4 on our test server.

Thanks for your help....  :o)

memcneely
Microsoft Server OS
Microsoft Server OS

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.

59K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo