Is there a complete drop and recreation of the table on the subscriber? I suspect that something is different in the schema, or the refresh is not configured correctly for...

Blocking is good, and necessary, as Grant mentioned.

Are you seeing long term blocking? Is there a specific issue, or did you just see blocks held in sp_who2?

The newsletter format has not changed in months. If they are not coming through, there is some type of filtering happening. Often Exchange people have a third party SPAM filter,...

ROFL, that is great.

The advice is

- domain user

- everyone group ONLY

- use SQL Server Configuration Manager to assign the account as the service account(s)

- add specific file share rights to access folders...

Not sure you want...

We're not the center of the...

These classes are for pay. The icon on the article shows this, and if you follow the links, the schedule and prices are listed.

GWAk (1/10/2011)

---

Allow me to turn this around just a bit...

If your ability to communicate via the written word is not the problem, but rather, the ability to communicate effectively, face-to-face,...

If you write the reversing transaction, then you should be OK, but you need to be sure this is what you want.

If you can, I'd write the reversing query in...

This might help as well: http://www.sqlservercentral.com/articles/2688/

GROUP BY - http://msdn.microsoft.com/en-US/library/ms177673%28v=SQL.90%29.aspx

Edit: wrong copy/paste

Log reader tools can help, but do you know what the large transaction was? If so, you can write the "reversing" transaction yourself.

I found this: http://www.sqlnewsgroups.net/sqlserver/t18795-32bit-sql-64bit-windows.aspx

If Linchi has done it, you should be OK.

Your plan should work, but I don't know that many people that have done it. Can I ask why...

Sounds like you know what to do.

If you get stuck in SSIS, post a note in that forum, and someone can likely help you.