SQL Server Performance Forum – Threads Archive

Dropping Table

Hi ALL, I tried to drop table from database by using query analyser its running forever… Is any clue why i am not anle drop that table. Thanks,
Sriram.

Check if there is other connection reading from or writting data into table. Sometimes canceling execution and executing again solves problem in query analyser.

Hi, i cancelled execution process n issued drop statement agian,still its running from past half hour. Thanks

Check sp_who2 in a seperate connection while executing your drop table command and see if there are any blocks. It sounds like a seperate connection is reading or writing to the table as ksmurthys mentioned. Thanks
Mike

Also run SP_LOCK to see the locking information during this process. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi MC_DBA,
When I checked using sp_who2 i am getting following output SPID Status Login HostName BlkBy DBName Command CPUTime DiskIO LastBatch ProgramName SP
51 Sleeping Mills . 51 EDWD_Mills SELECT 0 0 12/17/2004 16:40:52 51
51 Sleeping Mills . 51 EDWD_MILLS SELECT 0 0 12/17/2004 16:40:52 51
51 Sleeping Mills . 51 EDWD_mills SELECT 0 0 12/17/2004 16:40:52 51
51 Sleeping Mills . 53 EDWD_Mills SELECT 0 0 12/17/2004 16:40:52 51 Thanks,
Sriram.

]]>