Gail, the quick response is much appreciated. Also, nice presentation at PASS 2008.

The primary key is actually non-clustered, and I'm trying to delete a clustered index that's on the same column as the PK. I tried dropping the foreign key constraints which I found using:

select *

from sys.sysobjects

where xtype = 'F'

But I apparently didn't get them all because I was still not able to drop either index. FKs aren't enforced across databases are they?

I created the clustered index for testing purposes but found that it causes the CPU usage to soar, so I'm trying to drop it.

Hope that helps.

Thanks again,

Nate