To add a new column to a table and include it in an existing publication, you'll need to use ALTER TABLE <Table> ADD <Column> syntax at the publisher. By...

You need to look for additional details in Replication Monitor. If still no luck, enable verbose agent logging and inspect the agent log for the additional details.

How to enable...

You could have a corrupted installation or something else.

It is best to contact Microsoft Support and have them analyze the dump file.

If the snapshot transfer is interrupted it will pick up where it left off. It will not resend the entire snapshot again. This is covered in Initialize a...

You do not need to remove an article to drop a column. Dropping a column does not require reinitialization either. You do not need to generate a new...

You say this occurs when massive updates are performed. Notice the error Query timeout expired in your log. Try increasing the Distribution Agent -QueryTimeout parameter. The default...

This is a permissions issue.

If it is a Merge push subscription, ensure the Merge Agent process account is db_owner in the distribution database, a member of the PAL, a login...

The replication agent is trying to insert a duplicate primary key at the subscriber.

You will need to remove the row that was inserted at the publisher to resolve the error.

If...

To drop a column from an existing publication you'll need to use ALTER TABLE <Table> DROP <Column> syntax at the publisher. By default the schema change will be propogated...

For different source and destination table names you'll want to look at @destination_table parameter for sp_addarticle.

For different source and destination schemas you'll want to create an indexed view on the...

Hi SUPER SQL STAR,

Monitor replication with Replication Monitor.

http://msdn.microsoft.com/en-us/library/ms151780.aspx

Hope this helps.

Hi ysulieman,

Please ensure you have Automatic configuration turned off and proxy server disabled in Internet Explorer. Internet Explorer -> Tools -> Internet Options -> Connections -> LAN settings, uncheck...

Hi Elephant,

What does sp_who2 reveal? High IO/CPU? Is there contention for the distribution database?

If so, I've seen this happen when the distribution database gets very big like >...

Hi xigma,

I'm not sure deleting the log file was your best option here. A more appropriate thing to do when a subscriber's drive fills up like this is to...