-
2 VotesReminder - please indicate if a reply has answered your question.
How do I indicate a post answered my question? If a post has answered your original question, please indicate this by clicking on the "Mark as Answer" button ...Sticky | 4 Replies | 60004 Views | Created by Greg Y - Thursday, December 7, 2006 8:22 PM | Last reply by Harry SQL DBA - Saturday, February 19, 2011 5:43 AM
Found 12097 threads
-
0 Votes
SQL server 2016 Replication to Oracle 12102 Subscriber
exec sys.sp_MSrepl_ORAdatatypes 'Oracle', '12' >exec sys.sp_MSrepl_MSSQL_ORA_datatypemappings @source_dbms = N'MSSQLSERVER', @destination_dbms = N'ORACLE', @destination_version = ...Proposed | 4 Replies | 3540 Views | Created by Kiran Rangu - Tuesday, August 4, 2020 5:22 PM | Last reply by Cris Zhan - Monday, August 17, 2020 2:38 AM -
5 Votes
SQL Server 2019 snapshot agent error
Hello, I was trying to configure an SQL Server 2019 transactional replication, but the snapshot agent returns the following ...Proposed | 18 Replies | 20393 Views | Created by José.Cruz - Saturday, December 14, 2019 11:46 AM | Last reply by delicatelacero - Friday, August 14, 2020 11:46 AM -
0 Votes
Foreign keys being created on multiple subscribers
Have a publisher with a specific publication that has 1 article, and 4 subscribers. The subscribers are on 3 separate instances with the the same database name(database1) for 3 of the 4 subscribers. I ...Unanswered | 2 Replies | 3608 Views | Created by Abeljdang - Tuesday, August 4, 2020 6:35 PM | Last reply by Abeljdang - Thursday, August 6, 2020 6:30 PM -
0 Votes
"Invalid Operation" when adding Oracle subscriber to SQL Server 2016 replication publication
Hi, I'm trying to set up transactional replication from SQL Server 2016 to Oracle 12c. (I realize that heterogeneous replication is deprecated but this should be for ...Unanswered | 5 Replies | 6115 Views | Created by MartinBH - Monday, January 30, 2017 9:28 PM | Last reply by MartinBH - Tuesday, August 4, 2020 5:25 PM -
0 Votes
SQL Server Replication using RMO
We are using SQL Server replication using RMO. We have SQL 2016 (Standard Edition) on the server acting as the publisher and SQL Server Express Edition as the ...Proposed | 3 Replies | 3593 Views | Created by Amit Nerurkar - Saturday, August 1, 2020 2:03 PM | Last reply by Amelia Gu - Tuesday, August 4, 2020 6:04 AM -
0 Votes
[Announcement] SQL server related Forums will be migrated to a new home on Microsoft Q&A!
This SQL Server related Forum will be migrated to a new home on Microsoft Q&A! We’ve listened to your ... -
1 Votes
Configure Peer-Peer Replication with T-SQL
Hi Team, How to configure Peer-Peer Replication with T-SQL in SQL Server 2016? I am familiar with GUI but not with T-SQL. Please help ...Answered | 9 Replies | 3744 Views | Created by VijayKSQL - Tuesday, July 28, 2020 6:14 AM | Last reply by MIAOYUXI - Friday, July 31, 2020 1:30 AM -
0 Votes
Invalid operation. The connection is closed. - when adding Oracle subscriber to SQL Server 2016(13.0.5102.14) replication publication"
Hello, I am facing the issue when I try to add Oracle subscriber to SQL Server 2016 replication ...Unanswered | 5 Replies | 4950 Views | Created by Keeran kumar - Thursday, July 23, 2020 7:11 AM | Last reply by MIAOYUXI - Tuesday, July 28, 2020 1:02 AM -
1 Votes
DELETE A RECORD
Transaction replication. We have a bad record in the PUBLISHER DB for a particular program and currently working with the app company figuring out what happened. Anyway, ...Unanswered | 3 Replies | 3507 Views | Created by ARPRINCE - Wednesday, July 22, 2020 3:43 PM | Last reply by Cris Zhan - Monday, July 27, 2020 1:04 AM -
1 Votes
Peer-to-peer replication not staying in sync
We have set up a simple test of peer-to-peer replication with three nodes, A, B, and C. Node A has the peer originator ID set to 100, node B is set to 90, and node C is set to ...Answered | 4 Replies | 3607 Views | Created by lehrsj24 - Thursday, July 23, 2020 3:32 PM | Last reply by Cris Zhan - Monday, July 27, 2020 12:59 AM -
0 Votes
Replication Monitor 18.5x not connecting automatically to all publishers
Our sysadmin approved a WSUS push of SSMS 18.5 last week. I believe I had been running 17.92. My normal morning routine starts with launching SSMS and starting Replication Monitor ...Unanswered | 11 Replies | 4990 Views | Created by A Random DBA - Wednesday, July 8, 2020 1:40 PM | Last reply by MIAOYUXI - Friday, July 24, 2020 9:29 AM -
0 Votes
Transactional replication failing with connection was forcibly closed
Hi, I have pull transactional replication setup. When there is a little load of transactions it starts failing with below error. Agent message code ...Unanswered | 6 Replies | 6062 Views | Created by Udham Singh - Friday, July 3, 2020 6:00 AM | Last reply by MIAOYUXI - Friday, July 24, 2020 9:24 AM -
0 Votes
Computed Column at publisher end not replicating at subscriber end
Hi I do have Publisher Table and Subscriber Table , both has same schema , Difference is publisher table has one computed column which return varchar Like Sample Below: CREATE ...Unanswered | 2 Replies | 4006 Views | Created by Ujjwal_Jain - Wednesday, July 22, 2020 2:36 PM | Last reply by Ujjwal_Jain - Thursday, July 23, 2020 11:49 AM -
0 Votes
Why am I unable to skip a transaction in SQL Server 2017 transactional replication using the sp_setsubscriptionxactseqno stored procedure?
0 rollback tran (Transaction sequence number: 0x00036322000B2628000100000000, Command ID: 1) Error messages: The row was not found at the Subscriber when applying the replicated ...Unanswered | 3 Replies | 5312 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 -
2 Votes
Change Tracking Performance
146316152 ; The difference in the execution plan is the first one does an index seek on syscommittab using some scaler operator in the predicate where the second FASTER ...Unanswered | 6 Replies | 15445 Views | Created by J Reitz - Tuesday, June 29, 2010 11:15 AM | Last reply by Laxmidhar sahoo - Saturday, July 18, 2020 8:46 AM -
0 Votes
What if schema replication changes are disabled in snapshot replication.
I want to know if new table and columns along with data, will be replicated to subscriber database if I have disabled schema replication in publication ? It's snapshot ...Answered | 3 Replies | 4400 Views | Created by V Jay Rana - Friday, July 10, 2020 10:00 PM | Last reply by MIAOYUXI - Tuesday, July 14, 2020 1:11 AM -
1 Votes
TCP Provider: An existing connection was forcibly closed by the remote host. (Source: MSSQLServer, Error number: 10054) Get help: http://help/10054
Hi Team, we have 1 replication setup on production server.Publisher and distribution are on same server and subscriber is at other end. We are getting above error ...Proposed | 3 Replies | 66114 Views | Created by Anu321 - Friday, July 14, 2017 5:40 AM | Last reply by Shivendoo Kumar Dubey - Friday, July 10, 2020 5:39 AM -
0 Votes
sp_MSunmarkreplinfo blocking queries
I'm investigating the slowdown of a system and am finding sp_MSunmarkreplinfo is blocking. It is trying to get a schema modify lock but is being blocked by other things. This ...Unanswered | 12 Replies | 4837 Views | Created by NigelRivett - Sunday, June 28, 2020 12:19 PM | Last reply by NigelRivett - Monday, July 6, 2020 11:08 PM -
2 Votes
Transactional Replication - Snapshot Agent can not start when using remote distributor
Hi everyone, i created a transactional replication (SQL Server 2019) with two different servers. there are in different ...Answered | 10 Replies | 5995 Views | Created by huisky - Wednesday, July 1, 2020 12:34 PM | Last reply by Melissa Ma - Monday, July 6, 2020 1:16 AM -
1 Votes
Configure Publication error when using remote distributor
hi,all i have added servername\repl_logreader,servername\repl_snapshot in sqlserver Logins.. and done everything for creating publications using remote ...Unanswered | 21 Replies | 6874 Views | Created by huisky - Monday, June 29, 2020 11:26 AM | Last reply by MIAOYUXI - Monday, July 6, 2020 1:03 AM - Items 1 to 20 of 12097 Next ›
