Got the Primary Keys created, thanks for the hints.
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
You don't know how much I am thanking you already.
JOhn :}
>Just drop the clustered index on calldate (there is already a normal
>index on calldate).
----- Whatever you do, work at it with all your heart, as working for the
Lord, not for men >Colossians 3:23 (NIV)
John C. Lange, Sr. PALACE dot NET, INC.
microjl@palacenet.net MICRO-TECH Computers, Inc.
608.742.1601 & 6980 1819 New Pinery Road
http://www.palacenet.net/ Portage, WI 53901
MSCE Training for only $150.00 - http://dpec.palacenet.net/
All 200+ Web Based Courses for $150.00 Per Year - "Really"
--- __o
--- _-\<,_ Fastest Service in Town
--- (_)/ (_)
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart