Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    23

    Thumbs down Unanswered: Warning about SP3 for MSSQL2000

    We applied SP3 to a database which was a replication publisher, and it could no longer produce snapshots. I don't have the exact error message, but it was something like "mdac/bcp type mismatch".

    There is a Service Pack 3a -- I recommend it over SP3. SP3 can cause problems, including start-up and MDAC problems.

    See:

    http://www.microsoft.com/sql/downloa...=EN-US&gssnb=1

    http://support.microsoft.com/?kbid=814572

    http://support.microsoft.com/?kbid=814410

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Have you referred it to MS SUpport, I'm sure there should be way.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    May 2003
    Posts
    23
    Satya,
    SP3a corrected the problem. I was just posting this as information.
    But, thanks for the response.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •