Re: Dropping a uniwue clustered index HELP

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 03/31/05 

Date: Thu, 31 Mar 2005 00:14:03 -0600

Hi,

Please do this operation while there is no access to the table
TRt_lu_Trans_Subtype. If you try to drop this index while some one is
accessing
the table will cause Locks. You can view the blovks using sp_who command.
See the the Blocked column in the output.

Thanks
Hari
SQL Server MVP

"marcmc" <marcmc@discussions.microsoft.com> wrote in message
news:6057E1B7-89F4-4CEC-825D-04DB32A268A5@microsoft.com...
> -- CREATE UNIQUE CLUSTERED INDEX [IX_TRt_lu_Trans_Subtype] ON
> [dbo].[TRt_lu_Trans_Subtype]([Tr_sub_type_id], [Tr_type_id]) ON [PRIMARY]
>
> drop index TRt_lu_Trans_Subtype.IX_TRt_lu_Trans_Subtype
>
> is taking forever, Why?
>
> This is really urgent