Answer Posted / anand k

the magic tables are deleted and inserted.
while we are inserting or deleting a rows into a object the
magic tables were created and after the commit transaction
the tables are removed.so it is called magic tables

Can we write trigger for view?

1071

---

What are the advantages of log shipping?

1039

---

How do I setup a local sql server database?

1070

---

What is collation?

1195

---

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

---

Explain sql delete command?

1091

---

can you instantiate a com object by using t-sql? : Sql server database administration

1043

---

After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas

1009

---

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

1030

---

How extra digits are handled with numeric data type literals?

1031

---

What is order of B+tree?

1153

---

What is a non equi join?

1023

---

Why we use trigger in sql server with example?

1014

---

What is checkpoint process in the sql server?

1074

---

what is package and it uses and how can u call a package

2067

---