What is merge replication? This allows both publisher and subscriber to work independently, online or offline and merges the changes later. Here changes are track on both publisher and subscriber and then merged.

How does merge replication works? What are advantages and disadvantages of Merge replication? What is conflict resolution in Merge replication? What is a transactional replication?

What is a transactional replication? It is used when changes are frequent. The replication agent monitors the changes at the publisher and distributes the changes to the subscribers.Transactional Replication is required where up to date data is requi...

What are data type concerns during replications?

What are the uses of Replication? a) Server to Server Replication:- 1. Improving scalability and availability 2. Data warehousing and reporting 3. Integrating data from multiple sites 4. Integrating heterogeneous data 5. Offloading batch processing b)...

What are the Agents used for Transactional Replication? a) Snapshot Agent b) Log Reader Agent c) Distribution Agent 37)What are the Agents use

What is the Process of Transactional Replication? Three Agents are doing the Process for Transactional Replication

What is Replication ? Replication is the process of distributing data from one database to another on the same server or servers connected through LAN or the internet. Replication is used to synchronize data between databases that may be at remote lo...

System Triggers The syntax for creating a system trigger is very similar to the syntax used for creating DML trigger SQL> CREATE TABLE session_info 2 (username VARCHAR2(30), 3 logon_date DATE, 4 session_id VARCHAR2(30), 5 ip_addr VARCHAR2(30), 6 hostname...

Top 10 Features of SQL 2008 R2 1. Report Builder 3.0 2. SQL Server 2008 R2 Datacenter 3. SQL Server 2008 R2 Parallel Data Warehouse 4. StreamInsight 5. Master Data Services 6. PowerPivot for SharePoint 7. Data-Tier Application 8. Unicode Compression 9....