Drop Trigger, hangs

[johndweidauer]

trying to drop a trigger on a table, but it just hangs, for hours...where do I begin looking as the cause of this issue? entire database is less than 1gb, table is maybe 300mb (varies), I am not sure where to begin?

 

[Crowley16]

first, open up activity manager and identify the suspended/running spids, if it's suspended (which it should be) then there'll be an indication of why.

the drop of a trigger is just a meta data change so should not take any time at all.

I suspect your drop statement is blocked by something else holding a schema lock on the table.

Either that or your server/database is having some serious problems...

--------------------
Procrastinate Now!