Concurrent Stored Procedure Execution 
Author Message
 Concurrent Stored Procedure Execution
In a stored procedure, I use a temporary table (call it #stack) to store
some information (I have to do this to get around an EXECUTE issue).

I am wondering if I should dynamically create the name of the table and
use a userid to make it unique in case the stored procedure is executed
more than once at the same time.

Is this necessary?  Any help would be greatly appreciated.



Mon, 23 Dec 2002 03:00:00 GMT
 Concurrent Stored Procedure Execution

In a stored procedure, I use a temporary table (call it #stack) to store
some information (I have to do this to get around an EXECUTE issue).

I am wondering if I should dynamically create the name of the table and
use a userid to make it unique in case the stored procedure is executed
more than once at the same time.

Is this necessary?  Any help would be greatly appreciated.



Mon, 23 Dec 2002 03:00:00 GMT
 Concurrent Stored Procedure Execution

You don't have to do that, SQL Server does it automatically for you.
By design, when you create a local temporary table (#table_name), it is only
available to the session that created the table. So, if you have many
connections, each one creating the same local temporary table, each
connection will have a different table.
--
Hope this helps...
---------------------------------------
Carlos Eduardo Rojas
MCSE + I, MCDBA, MCSS
Please reply only to the newsgroups

Quote:
> In a stored procedure, I use a temporary table (call it #stack) to store
> some information (I have to do this to get around an EXECUTE issue).

> I am wondering if I should dynamically create the name of the table and
> use a userid to make it unique in case the stored procedure is executed
> more than once at the same time.

> Is this necessary?  Any help would be greatly appreciated.



Mon, 23 Dec 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. WLM and concurrent Stored Procedure load

2. concurrent worksc in stored procedure

3. concurrent access of a stored procedure

4. concurrent access of a stored procedure

5. Concurrent ASPs executions ???

6. MSDE: Little Concurrent Execution Limits Test

7. Concurrent Package Execution via dtsrun

8. Concurrent execution of DTS??

9. Turn Off Trigger Execution from a Stored Procedure?

10. Forcing Sequential Execution on Stored Procedures ...?

11. Execution stored procedures from MS Access 2.0

12. Cancel Stored Procedure execution


 
Powered by phpBB® Forum Software