meta user
network profile
| bio | website | khayata.org |
|---|---|---|
| location | Dubai, United Arab Emirates | |
| age | 36 | |
| visits | member for | 7 months |
| seen | 3 hours ago | |
| stats | profile views | 3 |
I am a Computer Engineer. I have experience in Programming & Networking
|
3h |
awarded | Custodian |
|
3h |
comment |
How to properly clean Merge Replication Setup Also you are using a filter in the query ( and p.name = '') which is trying to select a publication which has no name. |
|
3h |
comment |
How to properly clean Merge Replication Setup I was trying your script in step 3, but it seems that trigger names in my case starts with MSmerge_ instead of ('ins' or 'upd' or 'del' ) like you presume, which is causing the list of drop trigger script to be empty, Is it expected to be different between systems ? |
|
4h |
awarded | Commentator |
|
4h |
accepted | SQL Server Replication Alternative Software |
|
4h |
comment |
How to properly clean Merge Replication Setup Also the other answer in step 5 is referring to run a script to delete left behind triggers even after dropping everything using T-SQL commands!! so this means even if I use T-SQL commands, I still might have some replication meta data left in the setup!! Is this really possible ? Is there any Official Microsoft document to clarify how this should be done ? |
|
4h |
comment |
How to properly clean Merge Replication Setup Yes, You are right, I used GUI to drop subscriptions and publication and also disable publishing & distribution, but why using The GUI is different than using T-SQL commands ? isn't it at the end the same commands executed in the background ? |
|
2d |
asked | How to delete orphaned records from sysmergesubscriptions table? |
|
2d |
asked | How to properly clean Merge Replication Setup |
|
2d |
comment |
SQL Server Replication Alternative Software Thanks for your feedback, I have already commented in the other answer. |
|
2d |
comment |
SQL Server Replication Alternative Software I will try to post today new questions about some of the issues I am facing with the current setup so we can try to investigate it more further. |
|
2d |
comment |
SQL Server Replication Alternative Software Thanks for your feedback, I have already contacted Microsoft regarding multiple issues we faced which eventually seemed to be a bug in their product, but the problem is that each time I face an issue, it is taking too much time to investigate & solve it in accepted time frame for our business, so for that we were looking for another solution. |
|
Jun 16 |
revised |
SQL Server Replication Alternative Software corrected spelling |
|
Jun 15 |
asked | SQL Server Replication Alternative Software |
|
Feb 16 |
comment |
How to troubleshoot SQL Server Merge Replication Conflict? After trying your approach for a few days, it seems that it is not catching all changes that is made to one table!! Is there any better way to troubleshoot these issues? |
|
Feb 12 |
comment |
How to troubleshoot SQL Server Merge Replication Conflict? I will give a try to your Auditing method & try to find the issue. |
|
Feb 11 |
awarded | Vox Populi |
|
Feb 11 |
awarded | Suffrage |
|
Feb 11 |
awarded | Editor |
|
Feb 11 |
revised |
How to troubleshoot SQL Server Merge Replication Conflict? Formatting |
