Internal Query Processor Error:

  • execute (@Command) makes no difference, same error

  • can u check adding selects one by one i.e. first just run the 'MenuItem' select then add 'MenuItemVersion' in the @command variable this might help to get at which point / query it starts to fail.

    HTH.

  • The message is caused when I drop a database and then recreate it (GRD_RESTORE_INFO). It seems to get it nickers in a twist and says cannot find database id 14 which was the previous db id. The new one is 13 but the scripts has a problem finding it.

  • Just a last stab at the problem.

    Can you tried DBCC DROPCLEANBUFFERS, DBCC FREEPROCCACHE to see if it makes any difference before executing the code

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply