Because the application that uses the 2nd db creates 40 tables per user.   As this is a secondary application which our team does not have any role in supporting other than providing connectivity...

Yep thats what I did.  As you said I thought cross db ownership chaining was a bit drastic in this instance.

Thanks Guys, I thought the solution would be far more complex and overlooked the simple solution. 

Anyway, I've got it working.  Thanks again.

Thanks wz700,

I did not know that when a exec statement was run it ran a new session.  So thankyou for that.

However, where I have got (Rest of script goes here...) there is a...