What are the system database in sql server 2005?

0 Answers  

---

Do you know what is lock escalation?

0 Answers  

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---

Explain what stored procedure sp_replcounters is used for? : sql server replication

0 Answers  

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

What will happen if a column containing char type data is changed to the nchar data type?

0 Answers  

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

---

How can I create a report based on a query? : sql server management studio

0 Answers  

---

how can you check the level of fragmentation on a table? : Sql server administration

0 Answers  

---

If i have one transaction say mainTransaction, within this mainTransaction i have another two transaction say t1 and t2. Now while execution t1 completes successfully and commit statement fires, but while executing t2 some error occurs and rollback statement fires. What happen to t1, is it rollback or not?

1 Answers   Ness Technologies,

---

How do triggers work?

0 Answers  

---

What command do we use to rename a database?

0 Answers  

---