General information
Forum:
Microsoft SQL Server
Category:
Database management
For my understanding, any temp SP like #test#567 in Tempdb will drop automatically when user does not make connection with SQL SERVER.
We have one SQL 6.5, all the temp SP are still here even nobody makes connection. Until we restart SQL, those temp SP will be dropped.
1. Does anybody know this? Any 7 or 2000 experience is useful.
2. Could we write script to drop those SP?
Thanks
Jim
Next
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