hi Matey,

 You can try to drop one by one by using the following code.

 alter table [Table name]

drop constraint [constraint name]

cheers

sisi

hi,Can you check on the size of your table? I experience this before due to the size of the table is too big but after the partition, the CPu time...

hi, from the SQL profiler, it showed the long CPU and duration for Audit logout event. eg 12940 for CPU and 621000 for duration. could it be the different user using...

Thanks for the link.

My hardware setup is raid 5, intel xeon 3 GHZ processor with 3 GB RAM.

The CPU usage will hit 100% when there is a lot of user...