KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I realize that temporary tables are session/connection bound and not visible or accessible out of the session/connection. I have a long running stored procedure that creates temporary tables at various stages. Is there a way I can see the list of current temporary tables? What privileges do I need to be able to do so? Alternatively, Is there a way I can see the particular SQL statement being executed inside a running stored procedure? The procedure is running as a scheduled job in SQL Server. I am using SQL Server 2000. Thanks for your guidance.
Tags (comma-separated)
Save Edits
Cancel