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.

For more information about this list (including removal) go to: