Answer / hari

Snapshot is the a picture or snapshot of the databse is
taken peridicalloy propgated to the sbuscripber.
it does't invole continuesly.

only read only

transcation replication : This can be used to replication
changes to the database with this any changes made to the
replication data immediately caputred from transcation log
and propogated to the distributor

Answer / gowtham

In snapshot replication we ccan take the copy of the database
from publisher and put it into the subscriber,here it is in read-only mody it will not allow us to make any modifycations

In Transactional replication it is a oneway commite if we did any modifications in publisher those modifications will be replicated to suscriber (here the log rederagent captures the
changes in suscriber from transactional log and it moves to the distibutor).

Can we add our custom code in ssis?

0 Answers  

---

how to avoid cursors? : Sql server database administration

0 Answers  

---

What is a transact-sql statement batch in ms sql server?

0 Answers  

---

Explain the use of containers in ssis?

0 Answers  

---

Characterize join and name diverse sorts of joins?

0 Answers  

---

How to execute a sql statement using mssql_query()?

0 Answers  

---

What sql server means?

0 Answers  

---

What is raid and what are different types of raid levels?

0 Answers  

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

what is macro?

5 Answers   Excel, Global Innovation, Wipro,

---

What is difference between global temporary tables and local temporary tables?

0 Answers   Tech Mahindra,

---

How to genrate automaticlly empid like gt001

4 Answers  

---