my heap table has fragmented to 70%. i want to defragment. to defragment heaps i need to create and drop the cluster index. i need my existing non-cluster indexes.

adam thanks for you reply.

if you check the script i pasted in my previous post i menstioned online=on.

but my question is non-cluster indexes recreates automatically when cluster index creates or...

thanks crever for your answer.

thanks david.

thanks for all your replies

yes stored proc is in master database.

sp_help will work on encrypted procs. when u use sp_helptext it says it has encrypted text.

i tryed sys.all_object, sys.procedures but no luck.

no luck there are no synonyms

it is tsql step. he selected database

in tsql it is just "exec dbo.sp_abc". i went into the database tryed sp_helptext no use. he used this procedure for every...

thank you david and yuri,

how does table references work. do we need to declare references on stage table( which are going to get in partition table)

yes it is sql 2005 sp2 enterprise edition