Seems pretty good except for the bookmark lookup which may or may not be the problem.  Can you run the query again in QA and show the graphical execution plan,...

Send us the execution plan... there must be a scan somewhere that is grinding this thing down to a stop.

Run this and send us the results.

SET

I guess you could always build the create table statement in the proc and send it back to the calling proc ending the execution of the 2nd proc. Execute the...

Do you have indexes on all those columns??

t.TeamID, ot.BuyerTeamID, llu.LeagueLevelUnitID, t.LeagueLevelUnitID, ll.LeagueLevelID, llu.LeagueLevelID

Can you run this statement? And how fast does it run ? :

Select * from dbo.LeagueLevels where ll.LeagueID...

Or even something as subtile as having a varchar column joining to an nvarchar column can cause implicit_converts which can cause scans.  This can be a big headache to find...

I don't know any other solutions since I've never had or met this problem. I'll keep thinking about it but I don't make any promises

Yup.... but as I said, I was just thinking out loud so it might not work at all .

How about creating a database for them where only that kind of data is used?

You could give them high access there and they couldn't do much damage (unless they start...

Pretty much.  how is that not acceptable to your situation?

How about global temp tables?? (##temp instead of #temp)

I'm just glad we finished by getting it right in the end.

How many exceptions did you find? (total and percentage)

Netscape and IE do it to so it's reallllllllllly unlikely to be linked to the browser.

I see.  I've never met that problem so I'll let the other dbas take this one.  Good luck .

Why can't you run the update directly in the openquery or using a linked server??

What information are you missing from those logs?