Viewing 9 posts - 1 through 9 (of 9 total)
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...
July 30, 2015 at 3:31 pm
siggemannen (3/10/2013)Maybe you should take a look at Service Broker architecture if deadlocks are a big problem? All changes will be applied sequentially?Alternatively try to understand why they occur.
Alternatively try to understand why they occur.
March 10, 2013 at 5:31 pm
I'm not exactly sure what you are looking to do, it would be helpful if you would provide some DDL to have a look .
DECLARE @retry INT = 3;
March 8, 2013 at 8:13 am
Here is sample SQL code for my SProc:
DECLARE @waitForTime CHAR(8) = '00:00:01'-- 1 SECOND
DECLARE @ErrorMessage nvarchar(4000);
DECLARE @ErrorSeverity int;
DECLARE @ErrorState int;
DECLARE @TranCount int = @@trancount;...
March 2, 2013 at 1:15 pm
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
February 28, 2013 at 2:42 pm
So I am not hearing anyone disagree with my conclusion that there is no way to accomplish this...:ermm:
February 28, 2013 at 7:28 am
February 27, 2013 at 12:46 pm
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
May 26, 2012 at 9:39 am
James Luetkehoelter (4/17/2008)
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...
April 29, 2008 at 2:05 pm