General information
Forum:
Microsoft SQL Server
No, if two people call a stored procedure, each procedure would have their own private copy of any LOCAL cursors. If you create a cursor, or local temp table, and look at tempdb, you will see that a unique number is added to the table name.
>Hi Bob,
>
>When you say LOCAL to the stored procedure (SP) you mean to all users, that call that SP?
>
>Ricardo
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only