Answer Posted / subbu

Newly introduced in Sql server 2005
======================================
DDL trigger (This trigger fired only create new table or
Drop table or Alter table).Created in either Database or
Server.
To Deploy .Net procedures.
CLR Integration.
TRY & CATCH Mehod (For Error Handling).

Define full outer join in sql server joins?

501

---

Explain what are the events recorded in a transaction log?

557

---

Explain the third normal form(3nf)?

523

---

Does server sql treat char as a variable-length or fixed-length column?

588

---

What are the database roles? : sql server security

566

---

---

Is sql different from sql server?

517

---

what are constraints? : Sql server database administration

527

---

What are the types of indexes?

598

---

what authentication modes does sql server support? : Sql server database administration

525

---

How is sql server used?

549

---

What are system databases into sql server (2005/2008) : sql server database administration

573

---

plss anybody specify tha constrian management system in dbms

1573

---

What is the difference between a fill factor of 100 and 0?

536

---

Tell me can we use custom code in ssrs?

601

---

What samples and sample databases are provided by microsoft?

577

---