Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating cursors
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00432822
Message ID:
00434400
Views:
12
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
Map
View

Click here to load this message in the networking platform