We use views for row level security (2008 R2) and found that you need to add "WITH CHECK OPTION" to the view or else users can insert data into the...

we...

DECLARE @retry INT = 3;

DECLARE @waitForTime...

Here is sample SQL code for my SProc:

DECLARE @retry INT = 3;

DECLARE @waitForTime CHAR(8) = '00:00:01'-- 1 SECOND

DECLARE @ErrorMessage nvarchar(4000);

DECLARE @ErrorSeverity int;

DECLARE @ErrorState int;

DECLARE @TranCount int = @@trancount;...

thanks you for all the help - today is crazy day at work - tomorrow I will try to post some portion of the SQL involved to help clarify

So I am not hearing anyone disagree with my conclusion that there is no way to accomplish this...:ermm:

Cadavre (2/27/2013)

---

Read up on XACT_ABORT. XACT_ABORT is by default set to OFF in most instances for code in SQL Server, but inside a trigger it is set to ON by...

thank you - the developer add columns in the publishing database to the end of the table

but put them in the middle in the subscriber db

James Luetkehoelter (4/17/2008)

---

A great article, but...

I fundamentally disagree with using replication as a DR technique. Even with 2005, I've run into too many clients that often use replication to keep...