Markus (1/2/2014)
I guess the question remains... why would you drop a clustered index on a table?
I can see doing it only if you need to change the keys for something like partitioning but, even then, I believe a REBUILD will do it. Other than that, I can't see doing it.
Point well taken though.
@SQL Crazy Kid,
Why do you need to drop the Clustered Index?
--Jeff Moden
Change is inevitable... Change for the better is not.