No announcements
Found 4092958 threads
-
0 VotesScript to skip failed transaction of article
Hi RajeshSql, We can skip errors in Transactional Replication using the Distribution Agent -SkipErrors parameter or by using ...Answered | 1 Replies | 3661 Views | Created by RajeshSql - Wednesday, June 13, 2012 1:13 PM | Last reply by Brandon Williams - Thursday, June 14, 2012 2:48 AM
-
0 Votes
Transaction replication distributor to subscriber is pending status
sp_setsubscriptionxactseqno Here is documentation on how to use this command:Answered | 11 Replies | 2745 Views | Created by ashwan - Wednesday, February 27, 2019 11:31 PM | Last reply by AV111 - Thursday, March 21, 2019 3:40 PM -
0 Votes
Transactional Replication - SQL Server 2012
looking for a book on SQL Server 2008 Administration?Answered | 5 Replies | 2264 Views | Created by vensyd - Thursday, February 27, 2014 2:40 AM | Last reply by Hilary Cotter - Thursday, February 27, 2014 2:37 PM -
0 Votes
transactional replication - replicating new stored procedures
Yes, each time you create a new stored procedure in the publisher, and if you need it to be replicated, then you need to check those int he articles and then regenerate ...Answered | 1 Replies | 7155 Views | Created by Jeff at work - Monday, March 28, 2011 8:08 PM | Last reply by Ashwin Menon - Tuesday, March 29, 2011 6:27 AM -
3 Votes
Transactions and stored procedures
Hi SQL Server will acquire an exclusive lock before the UPDATE/Delete/Insert and release it after the COMMIT (implicit or ...Answered | 3 Replies | 1128 Views | Created by Anniicca - Monday, February 2, 2015 5:11 PM | Last reply by davidbaxterbrowne - Monday, February 2, 2015 6:18 PM -
0 Votes
Transactional replication
Can we able to setup transactional replication for the tables without a primary key?Answered | 1 Replies | 1080 Views | Created by vinodh k - Wednesday, November 28, 2018 1:34 PM | Last reply by Shanky_621 - Wednesday, November 28, 2018 2:22 PM -
1 Votes
Transaction replication
That's by design of the transactional replication: If you replicate changes, some spMSupd..., spMSins.. and spMSdel... stored procedures get fired to apply ...Answered | 1 Replies | 6195 Views | Created by jitu.1221 - Thursday, February 12, 2009 6:17 AM | Last reply by Bodo Michael Danitz - Thursday, February 12, 2009 11:09 AM -
0 Votes
SQL Server Transactional Replication and WF
looking for a book on SQL Server 2008 Administration?Answered | 2 Replies | 1117 Views | Created by Rubikx - Thursday, February 25, 2016 8:47 AM | Last reply by Hilary Cotter - Wednesday, March 2, 2016 1:35 AM -
0 Votes
Transactional Replication Issues
best way to skip individual transactions is to put the transaction in a stored procedure, replicate the execution of that ...Answered | 15 Replies | 12059 Views | Created by Mohammad-Sufian - Thursday, April 22, 2010 6:39 PM | Last reply by Hilary Cotter - Tuesday, December 28, 2010 2:43 PM -
0 Votes
Why am I unable to skip a transaction in SQL Server 2017 transactional replication using the sp_setsubscriptionxactseqno stored procedure?
reinitialize the Subscriptions(Use a new snapshot) .Unanswered | 3 Replies | 5305 Views | Created by Wayne E. Pfeffer - Thursday, July 16, 2020 6:47 PM | Last reply by Cris Zhan - Tuesday, July 21, 2020 2:38 AM -
0 Votes
Manage transactions in multiple stored procedures
Please ...Answered | 4 Replies | 5443 Views | Created by Maju V Poulose - Friday, September 13, 2013 11:56 AM | Last reply by SimpleSQL - Friday, September 13, 2013 3:38 PM -
0 Votes
SQL transaction replication
Thanks Mohammad, Can you please specify why it is a bad plan to use Windows 7 in production?Answered | 8 Replies | 5692 Views | Created by SAMSQL - Monday, May 10, 2010 9:39 PM | Last reply by Wissam Kosseifi - Tuesday, May 11, 2010 8:05 PM -
0 Votes
SQL Server Transactional Replication help
looking for a book on SQL Server 2008 Administration?Answered | 4 Replies | 4056 Views | Created by coolguy123SQL - Friday, March 30, 2012 3:56 AM | Last reply by coolguy123SQL - Friday, March 30, 2012 2:45 PM -
0 Votes
ADO.NET transaction flow to stored procedures?
Hi, In the code from your post, if any of the stored procedures fails then the transaction will be ...Answered | 2 Replies | 6189 Views | Created by MJ Kay - Wednesday, October 20, 2010 10:54 PM | Last reply by Nikhil Shah - Thursday, October 21, 2010 5:10 PM -
0 Votes
SQL 2005 Transactional Replication
I am using SQL 2005 so I don't think this works.Answered | 5 Replies | 7243 Views | Created by Matt Beach - Monday, July 26, 2010 10:00 PM | Last reply by Wissam Kosseifi - Wednesday, July 28, 2010 6:49 PM -
0 Votes
Open Transaction on the Subscriber Server - Transactional Replication
Brandon Williams (blog | linkedin)Answered | 3 Replies | 4330 Views | Created by Fazlu - Wednesday, July 11, 2012 10:24 AM | Last reply by Brandon Williams - Wednesday, July 11, 2012 4:43 PM -
0 Votes
SQL Server Transactional Replication
Hello , We have a Transactional Replication for a Database of size more than 800GB, replicating to more than 4 servers.Answered | 1 Replies | 1258 Views | Created by Reddy435 - Tuesday, May 31, 2016 10:57 PM | Last reply by HilaryCotter - Wednesday, June 1, 2016 1:13 AM -
0 Votes
Delivering replicated transactions - Replication seems stuck
This is Transactional Replication right?Answered | 8 Replies | 8329 Views | Created by Anil_Kumar_DBA - Tuesday, September 20, 2016 5:40 AM | Last reply by Anil_Kumar_DBA - Wednesday, September 28, 2016 5:34 AM -
0 Votes
Transactional Replication and use of Filters
looking for a book on SQL Server 2008 Administration?Answered | 3 Replies | 3935 Views | Created by Smudger33 - Friday, March 9, 2012 11:09 AM | Last reply by Hilary Cotter - Tuesday, March 20, 2012 2:23 PM -
1 Votes
Transactional Replication SQL2012
Statement Delivery method is using Stored procedure and Stored Procedure is using three part qualifier (<databasename>.Answered | 5 Replies | 935 Views | Created by Yetlaw - Wednesday, September 21, 2016 9:01 PM | Last reply by Hilary Cotter - Monday, September 26, 2016 2:50 PM - Items 1 to 20 of 4092958 Next ›
No announcements
