I just wanted to follow up on this issue. I finally just moved the procedure to the remote server and created a procedure on the local server to wrap the...

Okay, I finally just let the procedure run and it completed after 20 minutes

It seems that when I run the procedure on the...

I can paste the select statement from the procedure, paste it into QA and it returns a resultset in 3 seconds. I try to exec the procedure from the same...

I'm on my workstation, logged in to QA as the login that's being impersonated in the server mapping. I'm not using a SQL Server link, I'm using the "other data...

Yes that is correct. I'm executing a procedure on server A that's selecting from a table on server B.

I don't get an error, I haven't let the procedure run...

Bump...

Anyone?

That looks like it would work.

Do you know the column names in advanced? Or does it need to be dynamic?

You might want to look up "StoredProcedure object" in sql server books online. I've never used this, and there may be an easier method but...