SqlServer-QA.net

In case you have many snapshots generated within your Replication setup and having troubles in finding what kind of scheduled job is running during the time of snapshot publication. By default you coudl take help of system catalog MSsnapshot_agents and further query against sys.sysjobs or sys.sysjobsteps, not an easy to find out what is ...

Whenever the replication is configured, a set of agent profiles is installed on the Distributor, thsi profile will have a set of parameters that are used each time an agent runs. In addition to this the replication provides a default profile for each agent and additional predefined profiles for the Log Reader Agent, Distribution Agent, ...

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 availble within the SQL Server documentation such as ...

Here we are going to highlight the majority of tasks you need to perform whenever user complains or you observe about SQL Server Replication performance is affected, adversly. For any performance tuning issues there will be other factors involved including SQL Server, such as in replication the performance can be measured along the ...

select name as published_object, schema_id, is_published as is_tran_published, is_merge_published, is_schema_publishedfrom sys.tables where is_published = 1 or is_merge_published = 1 or is_schema_published = 1unionselect name as published_object, schema_id, 0, 0, is_schema_publishedfrom sys.procedures where is_schema_published = 1unionselect ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification Contents: New and Major Modifications FIX: Error message when you synchronize a merge replication in a replication topology that contains two or more re-publishers in SQL ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise EditionNotification Contents: New and All Modifications FIX: Some changes from subscribers who use SQL Server 2005 Compact Edition or Web synchronization ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard EditionNotification Contents: New and All Modifications  FIX: Changes in the publisher database are not replicated to the subscribers in a transactional replication if the publisher database runs exposed in a database mirroring ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard EditionNotification Contents: New and All Modifications FIX: When you start a merge agent, synchronization between the subscriber and the publisher takes a long time to be completed in SQL Server ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard EditionNotification Contents: New and All Modifications 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 ...