-
2 OylarReminder - 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 ...Yapışkan | 4 Yanıtlar | 60004 Görünümler | Created by Greg Y - 7 Aralık 2006 Perşembe 20:22 | Son Yanıt ile Harry SQL DBA - 19 Şubat 2011 Cumartesi 05:43
Found 12097 threads
-
0 Oylar
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 = ...Önerilen Yanıt | 4 Yanıtlar | 3540 Görünümler | Created by Kiran Rangu - 4 Ağustos 2020 Salı 17:22 | Son Yanıt ile Cris Zhan - 17 Ağustos 2020 Pazartesi 02:38 -
5 Oylar
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 ...Önerilen Yanıt | 18 Yanıtlar | 20406 Görünümler | Created by José.Cruz - 14 Aralık 2019 Cumartesi 11:46 | Son Yanıt ile delicatelacero - 14 Ağustos 2020 Cuma 11:46 -
0 Oylar
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 ...Soru | 2 Yanıtlar | 3609 Görünümler | Created by Abeljdang - 4 Ağustos 2020 Salı 18:35 | Son Yanıt ile Abeljdang - 6 Ağustos 2020 Perşembe 18:30 -
0 Oylar
"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 ...Soru | 5 Yanıtlar | 6117 Görünümler | Created by MartinBH - 30 Ocak 2017 Pazartesi 21:28 | Son Yanıt ile MartinBH - 4 Ağustos 2020 Salı 17:25 -
0 Oylar
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 ...Önerilen Yanıt | 3 Yanıtlar | 3594 Görünümler | Created by Amit Nerurkar - 1 Ağustos 2020 Cumartesi 14:03 | Son Yanıt ile Amelia Gu - 4 Ağustos 2020 Salı 06:04 -
0 Oylar
[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 Oylar
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 ...Yanıt | 9 Yanıtlar | 3744 Görünümler | Created by VijayKSQL - 28 Temmuz 2020 Salı 06:14 | Son Yanıt ile MIAOYUXI - 31 Temmuz 2020 Cuma 01:30 -
0 Oylar
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 ...Soru | 5 Yanıtlar | 4952 Görünümler | Created by Keeran kumar - 23 Temmuz 2020 Perşembe 07:11 | Son Yanıt ile MIAOYUXI - 28 Temmuz 2020 Salı 01:02 -
1 Oylar
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, ...Soru | 3 Yanıtlar | 3509 Görünümler | Created by ARPRINCE - 22 Temmuz 2020 Çarşamba 15:43 | Son Yanıt ile Cris Zhan - 27 Temmuz 2020 Pazartesi 01:04 -
1 Oylar
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 ...Yanıt | 4 Yanıtlar | 3609 Görünümler | Created by lehrsj24 - 23 Temmuz 2020 Perşembe 15:32 | Son Yanıt ile Cris Zhan - 27 Temmuz 2020 Pazartesi 00:59 -
0 Oylar
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 ...Soru | 11 Yanıtlar | 4991 Görünümler | Created by A Random DBA - 8 Temmuz 2020 Çarşamba 13:40 | Son Yanıt ile MIAOYUXI - 24 Temmuz 2020 Cuma 09:29 -
0 Oylar
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 ...Soru | 6 Yanıtlar | 6065 Görünümler | Created by Udham Singh - 3 Temmuz 2020 Cuma 06:00 | Son Yanıt ile MIAOYUXI - 24 Temmuz 2020 Cuma 09:24 -
0 Oylar
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 ...Soru | 2 Yanıtlar | 4006 Görünümler | Created by Ujjwal_Jain - 22 Temmuz 2020 Çarşamba 14:36 | Son Yanıt ile Ujjwal_Jain - 23 Temmuz 2020 Perşembe 11:49 -
0 Oylar
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 ...Soru | 3 Yanıtlar | 5313 Görünümler | Created by Wayne E. Pfeffer - 16 Temmuz 2020 Perşembe 18:47 | Son Yanıt ile Cris Zhan - 21 Temmuz 2020 Salı 02:38 -
2 Oylar
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 ...Soru | 6 Yanıtlar | 15446 Görünümler | Created by J Reitz - 29 Haziran 2010 Salı 11:15 | Son Yanıt ile Laxmidhar sahoo - 18 Temmuz 2020 Cumartesi 08:46 -
0 Oylar
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 ...Yanıt | 3 Yanıtlar | 4400 Görünümler | Created by V Jay Rana - 10 Temmuz 2020 Cuma 22:00 | Son Yanıt ile MIAOYUXI - 14 Temmuz 2020 Salı 01:11 -
1 Oylar
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 ...Önerilen Yanıt | 3 Yanıtlar | 66120 Görünümler | Created by Anu321 - 14 Temmuz 2017 Cuma 05:40 | Son Yanıt ile Shivendoo Kumar Dubey - 10 Temmuz 2020 Cuma 05:39 -
0 Oylar
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 ...Soru | 12 Yanıtlar | 4840 Görünümler | Created by NigelRivett - 28 Haziran 2020 Pazar 12:19 | Son Yanıt ile NigelRivett - 6 Temmuz 2020 Pazartesi 23:08 -
2 Oylar
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 ...Yanıt | 10 Yanıtlar | 5995 Görünümler | Created by huisky - 1 Temmuz 2020 Çarşamba 12:34 | Son Yanıt ile Melissa Ma - 6 Temmuz 2020 Pazartesi 01:16 -
1 Oylar
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 ...Soru | 21 Yanıtlar | 6880 Görünümler | Created by huisky - 29 Haziran 2020 Pazartesi 11:26 | Son Yanıt ile MIAOYUXI - 6 Temmuz 2020 Pazartesi 01:03 - Items 1 to 20 of 12097 sonraki ›
