sql server drop clustered property but retain primary key in replicated table

platform: windows 2000 server
db:      sql server 2000

I have a big trend table (loan_trend) which holds 30 million records + and growing each end of month. this table is replicated so there are PK constraints.

the problem is the original developer added an identity field (autoID) to satisfy PK requirements for replication but also made it a clustered index. This autoID clustered PK has no benefit for the many stored procs on this table so i want to change the clustered index to appropriate fields in that table.

i want to be able to drop the clustered property of this PK but not drop the PK itself. i dont want to do this using the GUI as there are several other big tables involved and I dont want to sit there watching the hourglass cursor during the upgrade (there are many other indexes being changed, stored procs etc) so I need this scripted in transact sql.

Also what would be the impact on replication? can i just switch off the replication, make the changes in the tables in both the original production db and replicated db, then switch replication back on?

thanksStart Free Trial