Browse by Tags

Replication FAQ - how to know Distributor and Publisher with scripts

Published 19 February 8 4:45 PM | SSQA.net

A newbie set of question that how to know the whether the current server is distributor or publisher? Any pre-defined script to know any other publishers that are using as Distributor? Well, there are such pre-defined scripts and stored procedures are...

Filed under: sql server, replication, snapshot, script, merge, publisher, transactional, distributor, schedule

Transactional Replication Snapshot Issues - useful resources to resolve

Published 16 January 8 1:8 AM | SSQA.net

When you have problems with SQL Server replication where the transactional replication is common case in setting up, eventually you will have problems when the data is growing up and any sudden changes in the ETL will also have affect on replication process...

Filed under: sql server, microsoft, security, replication, merge, transactional, tips, setup, links

SQL Server Replication - presentation from Scottish Area SQL Server User Group

Published 12 December 7 4:4 PM | SSQA.net

As a part of regular monthly meetings from Scottish Area SQL Server user group [ Scottish Area SQL Server User Group: Wednesday 12th December 18:30 - 21:00 : Edinburgh ] I have given a presentation on SQL Server Replication, type of SQL Server Replication...

Filed under: sql server, microsoft, replication, snapshot, best practices, merge, transactional, beginners, types

Replication FAQ series - Which columns are published in snapshot or transactional or merge publications in this database?

Published 11 December 7 6:48 PM | SSQA.net

Here is script you can find which columns are published in the replication that is using either snapshot or transactional or merge publications. --For snapshot or transactional publications select object_name(object_id) as tran_published_table, name as...

Filed under: sql server, replication, snapshot, merge, transactional, tsql, tables, columns, FAQ

MSDN labs - Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005

Published 11 December 7 10:11 AM | SSQA.net

Sometime ago I have blogged about MSDN labs- SQL Server Virtual Labs - fully featured virtual environment for testing! and I recommend and encourage all of my users to use Virtual labs and webcasts - use them for a better practice on product . Similar...

Filed under: sql server, msdn, technet, replication, best practices, virtual labs, merge, compact edition, mobile, developement

FIX: Some changes from subscribers who use SQL Server 2005 Compact Edition or Web synchronization are not uploaded to the publisher when you use the republishing model in a merge publication in Microsoft SQL Server 2005

Published 24 September 7 1:4 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, web, replication, kba, merge, subscriber, publisher, compact edition, synchronization, ce

FIX: You experience a slow uploading process if conflicts occur when many merge agents upload changes to the publishers at the same time in SQL Server 2005

Published 11 September 7 4:35 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: You experience a slow uploading process if conflicts occur when many merge agents...

Filed under: sql server, replication, kba, merge, agent, publisher

How to reinitialize a merge subscription from publisher - SQL 2005 using TSQL script?

Published 11 September 7 4:3 AM | SSQA.net

Lately we have had a requirement to re-initialize handful of subscriptions to a publication within the merge replicaton setup. I was looking for a way out to achieve these operations programmatically using a TSQL script. I'm aware that using SP_REINITMERGEPULLSUBSCRIPTION...

Filed under: sql server, update, replication, monitor, merge, publisher, subscriptions

FIX: A foreign key constraint that you drop on a table at the publisher is not dropped on the table at the subscriber in a SQL Server 2005 merge replication

Published 30 June 7 5:0 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: A foreign key constraint that you drop on...

Filed under: sql server, replication, kba, merge, subscriber, publisher

FIX: Error message when the Replication Merge Agent runs to synchronize a merge replication subscription in SQL Server 2005: “The merge process failed to execute a query because the query timed out”

Published 22 June 7 4:23 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when the Replication Merge Agent runs to synchronize a merge replication subscription in SQL Server 2005...

Filed under: sql server, query, replication, kba, merge, agent