Thank you for all your responses.

I have just checked for the error (I/O is frozen on Database) in the logs and did not see this at all....

Hey Guys,
Thanks for the responses. I have been out ill with the Flu all week so have not had a chance to look at all of your replies. I...

I was able to get around this by using dynamic within dynamic as follows. If anyone knows a better way I am all ears.

OPEN DBs

FETCH NEXT FROM DBs INTO @ClientID,...

No worries thank you very much for your assistance.

Hello Lynn,

Sorry I am having issues finding the link do you happen to have that. I would love to take a look to see the proper way for writing dynamic...

Thank you for your reply Lynn.

I already was as the Server and DBNames are passed in dynamically in a looping process. I guess I could do try to do...