Detect changes on indexes in a published table

Hi,

Regarding to my previous post at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=553652&SiteID=1, just wondering if there's a way to detect any changes which is made on the existing indexes in a published table so that the device can determine whether reinitialization of subscrption is needed before every synchronization.

Cheers,
Justin

One thing you may be able to use is DDL trigger. DDL trigger are fired in response to a variety of DDL statements, including create/alter/drop index. Just look for DDL trigger in BOL for more information.

Peng

|||

Yes, you may use special tools for compare structure changes

link http://www.red-gate.com/products/index.htm

sql

Detach db file with replication on

I cannot detach a db because replication is enabled . I wanted to detach
this published db so that I can move the files to another drive .
But at the same time, dont want to drop replication to do this. Is there a
way to be able to detach the db without dropping replication . ?
Hassan,
you could use backup and restore, however if the new server name is
different to the original, practically speaking, you'll end up having to
recreate the publications.
HTH,
Paul Ibison, SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Backup and restore may be a good option.. I can use the with move option and
do it.. Thanks..
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ep2Ot2MLFHA.3064@.TK2MSFTNGP12.phx.gbl...
> Hassan,
> you could use backup and restore, however if the new server name is
> different to the original, practically speaking, you'll end up having to
> recreate the publications.
> HTH,
> Paul Ibison, SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>

destination table not exist while adding column in published artic

I used the add_relpcolumn to add column in the published table but not
knowing that the subscriber database does not have the table. I found the
error on the distribution agent about 'Not able to alter the table because
the table doesn't exist', which explained what happened. As a result, it
breaks the replication. How do I fix the problem to make the replication
going again?
Thanks for any help in advanced
This sounds like a bug, could you post your publication script?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:FBAB2D4B-3DF5-47E5-ABF2-FF6634910114@.microsoft.com...
>I used the add_relpcolumn to add column in the published table but not
> knowing that the subscriber database does not have the table. I found the
> error on the distribution agent about 'Not able to alter the table because
> the table doesn't exist', which explained what happened. As a result, it
> breaks the replication. How do I fix the problem to make the replication
> going again?
> Thanks for any help in advanced