Answer Posted / sivakumar

Replication
Replication is the process of copying/moving data between
databases on the same or different servers.
SQL Server upports the following types of replication
scenarios:

Snapshot replication:
The Publisher sends a snapshot of the published data to
Subscribers at scheduled intervals.

Transactional replication:
The Publisher streams transactions to the Subscribers after
they receive an initial snapshot of the published data.

Merge replication:
The Publisher and Subscribers can update the published data
independently after the Subscribers receive an initial
snapshot of the published data. Changes are merged
periodically. Microsoft SQL Server Mobile Edition can only
subscribe to merge publications.

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

486

---

What is sql azure database?

188

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

599

---

What methods do you follow to protect from sql injection attack?

514

---

What number aggregate functions are accessible there in sql?

585

---

---

Explain raiserror in sql server?

569

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

501

---

List down some advantages of sql stored procedure?

552

---

How to use “drop” keyword in sql server and give an example?

683

---

What does sql server mean?

534

---

What is the command used to recompile the stored procedure at run time?

614

---

What is optimization and its types?

534

---

explain databases and sql server databases architecture? : Sql server database administration

515

---

What is update_statistics command?

572

---

Describe and explain about SQL native client?

610

---