Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
homebrew
Posting Yak Master
114 Posts |
 Posted - 2004-11-21 : 10:03:36
|
| Here's my predicament. I changed the filter on an article within a subscription, but not in a meaningful way. I just added "database.dbo." before a column name, but now my subscription is flagged for reinitialization, and won't replicate any transactions unless I start over with a new snapshot. I don't want that to happen. How can I reset the article properties somewhere to get it back the way it was and continue replicating transactions.(I needed to add "database.dbo" so that another job that looks at the filter info would point to the correct database. Next time maybe I'll just modify the table that stores the filter info) The reason I don't want to snapshot from the beginning is that I have procedures on the subscribing server that fire triggers from the transactions, so all the jobs "downstream" would get all out of sync. HELP ! |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-21 : 21:14:10
|
which is one of the reason you should avoid creating triggers and other additional stuffs on replicated tables.anyhow fyi, if you do begin the snapshot, only the article affected will be re-generated. the others won't.  --------------------keeping it simple... |
 |
|
|
|
|
|
Un-flag reinitialize flag for subscription