Used EM to find the locks. Kill the PIDs. Dropped the table.

Thanks Chip!

Aaron wrote:

> Any way to sort by table ?
>
> Chip Smith wrote:
>
>> Somebody has a transaction open.
>> Try sp_who sp_who2 and sp_lock to find out whom.
>>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Get today's cartoon: http://www.LazyDBA.com
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]

MS Sql Server LazyDBA home page