Answer Posted / sivakumar

Login is authentication into server level
And Users is authentication into object level.

What is data block and how to define data block size?

1026

---

What are the different acid properties?

1065

---

What is 3nf normalization form?

1111

---

Explain trigger and trigger types?

978

---

Difference between Sql server reporting services and Crystal reports?

168

---

How do I find the sql server database version?

1003

---

What are the general features of sql server management studio? : sql server management studio

1075

---

How does Report Builder support Analysis Services cubes?

153

---

What is the difference function and stored procedure?

1054

---

How will you decide the active and passive nodes?

1126

---

How to skip remaining statements in a loop block using continue statements?

996

---

What is the recovery model?

985

---

Where views are stored in sql server?

984

---

What is the full form of dql?

981

---

What is the difference between drop table and truncate table?

924

---