June 17, 2008 at 7:41 am
hi all, i am in a problem again, i think quite often these days,
last week I have migrated a replicated database from sql 2000 to sql 2005
the database involved replictaion after migration i have pusehd the database
to a sql 2000 subscriber, now the problem is I forgot to check the option
push the nonclustered indexes as it is selected by default in sql 2000.
Is there any way out that we can repush the nonclustered indexes without repushing,
the whole clustered indexes.
Thanks
June 18, 2008 at 3:01 pm
I did this once, and I scripted out all of the indexes. Most likely find script here to help generate CREATE INDEX code for your (non-clustered indexes) and execute them on your subscribers. Sorry for the bad news.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply