Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    51

    Unanswered: strange error in sql batch

    We have a sql batch script which runs as cron job on unix. The script gives error at some point saying 'The schema of the table T1 has changed since the compilation of query. Please rerun your command'

    The tables used have not changed for years.. The script uses #tables. We also noticed that DBCC runs when this job is running.

    Does anyone have any idea what this error could be?

  2. #2
    Join Date
    Jan 2005
    Posts
    10
    I have seen this error but it has been a while. Are update statistics running at the same time? It seems like it was related to update statistics being run on the table. After sp_recompile was run on the table the error disappeared.

Posting Permissions

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