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)...

Some times the session times out and you lose the message.  If you had to hit post reply twice to get the post working then that is what happened.

--This would take about 2 hours to run on my pc.

SELECT  TOP 999999999

  IDENTITY(int, 1,1) AS Demo

INTO   #Test

FROM   master.dbo.SysColumns C1

  CROSS JOIN master.dbo.SysColumns C2

  CROSS JOIN master.dbo.SysColumns C3

SELECT COUNT(*) AS...

Yup check out identity in the books online.