February 22, 2011 at 1:16 pm
how can i drop a temp table created by another user in his session?
February 22, 2011 at 1:21 pm
should be able to drop table database_name.user.temp
February 22, 2011 at 1:22 pm
how can i find the temp tables created by a user and drop the one i need?
February 22, 2011 at 1:29 pm
Assuming it's not a global temp table, then you'll have to kill the spid that holds the table alive.
Once the connection closes, the temp table will self destruct.
February 22, 2011 at 1:30 pm
You cannot.
- #tablename temp tables are cleaned up after the connection closes.
- ##tablename (global temporary tables) can only be dropped if they are no longer used by an active connection.
What kind of temp tables are you talking about ?
- #tablename
- ##tablename
What is your goal / problem ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 23, 2011 at 7:32 am
As ALZDBA, if your problem is with a local temp table, you need to follow Ninja's advice, kill the spid
--
Thiago Dantas
@DantHimself
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply