Answer Posted / yjreddy

there are 3 types

full
simple
bulk logged

What is Federation Root Database?

104

---

How to reaname table name without using sp_Rename in sql server..?

1039

---

Is it true, that there is no difference between a rule and a check constraint?

1111

---

What is the stuff and how does it differ from the replace function?

1227

---

Tell me can we use custom code in ssrs?

1054

---

What is the xml datatype?

1123

---

What is @@rowcount in sql?

1058

---

How do I find the default sql server instance?

990

---

What are the types of containers in ssis?

1234

---

What is a database table?

1025

---

Tell me what is sql profiler?

1083

---

What action plan is preferred if sql server is not responding?

1157

---

What is difference between rownum and rowid?

957

---

What is history table in sql server?

1029

---

What gets stored inside msdb database?

1309

---