Re: [NTISP] HERE is the whole script I ran THANKS
Dale E. Reed Jr. ( (no email) )
Mon, 31 Jan 2000 14:24:23 -0800
John Lange wrote:
>
> I tried several times to remove the clustered index. I created with:
> create clustered index cdateidx on calls2(calldate)
>
> then renamed the table to calls
>
> I tried:
> drop clustered index cdateidx on calls(calldate)
> drop index cdateidx on calls(calldate)
> drop index calls(calldate),cdateidx
>
> All to no avail. Please give me another hint, or put me out of my misery
> and tell me how
Go into Enterprise Manager, Right click over the table, and select
indexes. Select the cdateidx index, and select delete.
Sometimes EM, is easier to use than TSQL. :)
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart