July 30, 2003 at 1:36 am
execute (@Command) makes no difference, same error
July 31, 2003 at 7:31 am
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.
July 31, 2003 at 7:40 am
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.
August 6, 2003 at 7:12 pm
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