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...

execute (@Command) makes no difference, same error

will give it a go and let you know

They could go as separate calls but there should be no reason why this statement doesn't work

SQL 7.0 SP 3

NT 4.0 SP6

I tried that with the option plan statement at the end of end line but it worked the first time and thereafter I got the same error message.

ALready seen this but doen't seem to resolve my issue