Yeah whatever. Maybe not in title, but more knowledgeable than most.

There is not unless you created the package config or created a variable for the machine name.

If you did not create that, then when you run the package on a...

Good to hear. And despite the KBs, it would appear in this case that was the best solution.

Congrats Joe.

Best that can be done at this juncture.

Is the proc being called simultaneously? Can multiple connections call this proc at the same time?

Koen Verbeeck (12/20/2011)

I'm not locked in here with you! You're locked in here with me!

Ahem...

10...

Why start a new thread on this?

This cross posting only confuses and disjoints the answers.

Original post here

http://www.sqlservercentral.com/Forums/Topic1224878-391-1.aspx

can you post the script?

Are these fully materialized tables in the proc and not temp tables?

Could this proc be called from multiple sources at the same time?

Please post answers here:

http://www.sqlservercentral.com/Forums/Topic1224879-364-1.aspx

I'm with Jeff on this - have you monitored for blocking?

Nice and easy way to ease into mid-week.:-D

Please post responses to this thread

http://www.sqlservercentral.com/Forums/Topic1224842-391-1.aspx

Have a look at this thread and see if it helps

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/dd16e02a-57ff-42eb-8d90-2818798777df

K - you're welcome.