Well that is another problem altogether.  You need to figure out the normal max required size of temdb at any given time of the week.  Then you need to make sure...

You can't drop a temp table from someone else connection like that.

The only options you have all have one thing in common : kill all active connections on the server. ...

NP.

Also you'll have tokeep in mind that a single quote in the user name will break the query.  To avoid this situation you have 2 options

1 - use replace around...

Why would you want to do that?  Those tables will be automatically destroyed once the connection closes (or gets reassinged in the connection spool).

Unless you have a very serious problem...

Thanx Jeff.  The only part I'm not certain about is deadlocks.  Can you confirm that it is safe on that end?

I've seen many definitions of produtction DBAs.  I think that the best solution for you would be to ask your company what they will ask of you in the near...

This may need some work on the transaction part but here's the global idea :

begin transaction

update bt set spid = @@spid FROM dbo.baseTable BT inner join (SELECT TOP 10 id...

NP.  If you still have problems, you'll have to post the entire procedure so we may have a better understanding of what going on.

Good luck with that project.

It's only better if it works .

Try changing the code to table variables instead.  Make sure you test first to see if you have...

Are those global temp tables or are they created on the fly and destroyed after each execution.

U need to surround the username text with quotes in the query.  Or else the server will think you want to use the Zarandell column... which obviously doesn't exists in...

Another solution is to not use the function at all.  I know they are usefull for code reuse but in this case, the code is quite easy to remember.  Also...

What are the 2 users running on the server??

Is there any other task running (index defrag, databaseshrink, profiler, anti-virus)?

What's I see for the moment would be to bite the bullet and let it run for an hour while it inserts to a table once.  Then I'd build a...

USE SSC

GO

IF EXISTS (SELECT * FROM dbo.SysObjects WHERE Name = 'Demo' AND XType = 'U' AND USER_NAME(uid) = 'dbo')

 DROP TABLE dbo.Demo

GO

CREATE TABLE dbo.Demo

(

 a INT NOT NULL,

 B INT NOT NULL,

 c VARCHAR(20)...