What command do we use to rename a database?

0 Answers  

---

can you any body tell me which service pack is installed in the sql server?

3 Answers  

---

What is BCP? When do we use it?

2 Answers  

---

What is Files and Filegroups in SQL Server & it's implementation.

1 Answers   Zenith,

---

What are number line correlation administrators will use while working with a subquery?

0 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

Mention a few common trace flags used with sql server?

0 Answers  

---

Explain about merge replications?

0 Answers  

---

what are constraints? Explain different types of constraints? : Sql server database administration

0 Answers  

---

How to execute multiple stored procedures at one time in sql server?

0 Answers  

---

Explain Active/Active and Active/Passive cluster configurations

2 Answers  

---

How to delete duplicate rows in sql server?

0 Answers  

---