Service Pack 2 for SQL Server 2000 Released

• Brian Knight

  One Orange Chip

  Points: 27259

  More actions

  December 2, 2001 at 12:00 am

  #105048

  Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bknight/servicepack2forsqlserver2000.asp

  Brian Knight
  Free SQL Server Training Webinars

• Terry Grignon

  SSC Eights!

  Points: 840

  More actions

  December 20, 2001 at 3:29 pm

  #421347

  Thanks for the review. I have done the SP2 upgrade with no ill effects (but I'm in a development situation so what the hey, eh?)

  Just wondering ... do you know if the MDAC update applies if you only do the Desktop Engine update? Is there a way to tell which version of MDAC you are currently running?

  Thanks,

  Terry

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  December 20, 2001 at 3:52 pm

  #421348

  I dont have the URL handy, but MS has a MDAC component checker - should be easy to find on MSDN.

  Andy

  Andy
  Connect with me on LinkedIn

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  December 21, 2001 at 8:11 am

  #421358

  The web site to download is http://www.microsoft.com/data/download.htm#CCinfo

  I wanted it too so, while I was there I thought I would make it easy for others to find.

  Hope this helps and thanks Andy for the info.

  David

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

• Terry Grignon

  SSC Eights!

  Points: 840

  More actions

  December 21, 2001 at 8:58 am

  #421364

  Thanks both!

  I downloaded the MDAC component checker tool but it seems to only handle up to 2.61. I shall keep an eye open for a new version on the MS website.

  BTW: the version reported after an MSDE SP2 upgrade is MDAC 2.61.7326.6