Yes - much easier to manage in script if you are often breaking repl down for maint. Especially when your db has hundreds of tables.

Chris

Use the following - you can get this syntax by scripting out your own publication:

exec sp_addmergesubscription @publication = N'MergePubName', @subscriber = N'SubscrSvrName1', @subscriber_db = N'dbName', @subscription_type = N'Push'

,...

GUI is not most reliable method for managing repl - nor does it allow you to manipulate advanced features. Learn the sql scripts for administration

Use the following to add article...

ent manager - left click on first - hold shift - clikc on last - press delete key.

or - take output of this & exec in qa

select 'delete proc...

Definitely drop subscr, drop article, alter table, add article, add subscription. Run snapshot agent - if transactional repl snapshot only generated for affected tables.

Otherwise if you get around your...

What is a VCS Cluster - Veritas Cluster Service??

With MSCS you only deal with the "Virtual" istance of SQL. You register the virtual instance in management studio and configure this...

I can only assume you have a seperate dedicated distributor.

The passwords must match on both servers for distributor_admin sql login... if you don't know password - change at both...

KISS - I see so many companies using sql server that keep paying for crystal report when ssrs is amazing and built in, or they buy Informatica to solve etl...

Not necessarily. Pretty rare if it is also corrupt. Could occur if you initialized subscr w/ a corrupted backup...

Good Luck.

ChrisB MCDBA

MSSQLConsulting.com

Good. YOu are a c# programmer - take advantage of RMO

Lookup "Programming with Replication Management Objects" in books online.

Enjoy.

ChrisB MCDBA

MSSQLConsulting.com

You can do a couple of things.

1) Edit your replication stored procedures on subscribers. Replicated transactions call insert/update/del sp's on your subscriber. Open the insert & update and comment the...

Merge definitely has some latency issues - even when the agents are running continuously. Where the same row is updated the conflict resolver is very useful - you can monitor...

Did you start your snapshot agent? I leave my snapshot agent on a nightly schedule just in case I forget to start manually when adding articles...

Regards,

Chris B.  MCDBA MCSE OCP

Try to execute the sp_MSins call in Query Analyzer. You can delete that record after, or wrap in trans & rollback.

Is there a trigger on that table at subscr? (longshot)

I'm...

Interesting. Perhaps no transactions were replicated to that table until last night?

Is dbo the table owner?

Did you restart the agent successfully? Or is it still failing?

If still failing,...