Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696

    Unanswered: SQL 2005 to SQL 2000 Link Error

    Got the following error running a process this morning:

    ERROR: The OLE DB provider "SQLNCLI" for linked server "SEC-MASTER" reported a change in schema version between compile time ("95996848281392473") and run time ("95996848281392457") for table ""SecurityMaster"."dbo"."AccountingAttributionGrou p"".

    But there were no changes to the table specified, not much on this to be found via Google.

    Ran fine on a re-run, is there anyway to prevent this from happening ?

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Also, lazy schema validation for this link is set to 'False", so why would this appear ?

Posting Permissions

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