I found something about EXECUTE, but when I tried it, it told me I was trying to impersonate the user.

Maybe I was doing something incorrectly.

Can you suggest where I would...

Do you have a suggestion of how I should do it to not open myself up to sql injection attacks?

Does anyone see any problems to me giving the "User" ID of DB1 permissions in user mappings to DB2 with "db_datareader" permissions?

It seems to work, but wonder what doors I...

I am running SQL Server 2005 and I'm still getting the error I mentioned.

I followed the steps in this post and everything seems to work. However, I get an error "query execution failed for data set "CPU_UTILIZATION_HISTORY" User does not have...