I'm not totally against using dynamic sql.

But it can become more difficult to debug and maintain over time.

Also, there can be a performance loss.

Yes, I used COLLATE DATABASE_DEFAULT and the error went away.

So there is definatelly a collation issue with the two different databases.

Thanks a lot for your help.