Answer / jijo

Synchronizing data and object between systems .

For example i have 50gb data in Delhi server(Publisher or
source ) i need to replicate into tow locations one into
mumbai server 10gb data (subscriber ) and another one into
kerala server 20gb data.

Publisher ---Source
Subscriber ---destination
Distributor--- Receive from publisher and forward to sub

Type of replications

1)Snapshot (one way)
Data refresh of the subscriber every time you synchronize.

2)Merge Replication (Two way)
Both publisher and subscriber can make change to the data.
Conflict :- When two participant chenge the same row at same
time

3)Transactional replication
As change made at the publisher its send to the distributor
and distributor into subscriber

How except clause is differs from not in clause?

0 Answers  

---

What do you understand by intent locks?

0 Answers  

---

What is transaction server distributed transaction?

0 Answers  

---

what are the new features introduced in sql server 2000? : Sql server database administration

0 Answers  

---

can we call stored Procedure in Function in Sql Server 2000 and vice versa.

3 Answers   C3I, eSoft, iPRO Solutions, Wipro,

---

What is the difference between index seek vs. Index scan?

0 Answers  

---

What is difference between stored procedure and function?

3 Answers   L&T,

---

What is onf in normalization form?

0 Answers  

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

0 Answers   Accenture,

---

How to grant a permission in ms sql server using "grant execute" statements?

0 Answers  

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d f f g h

1 Answers  

---

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

2 Answers  

---