Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Temp Tables in SP's
Message
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00805519
Message ID:
00805558
Views:
46
>Local temp tables are application or user specific - which means that they are only visible to the connected user. Also, the server usually drops them when the user disconnects. Could this be part of the problem in your environment?
>

No, Good idea. But the table is being created in one stored proc, and attempted to be filled in another stored proc by the first. So that isn't the problem, but a good idea.

Morgan
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform