Answer Posted / anand

3 types of triggers
FOR/AFTER
I)DML Triggers
II)DDL triggers -introduces in SQL Server 2005
Instead OF triggers
LOGON Triggers -introduces in SQL Server 2005

DDL and LOGON are used to administrator related tasks

What is enhanced database mirroring in sql server 2008?

513

---

How to list all login names on the ms sql server?

533

---

What is analysis service repository?

585

---

What is meant by Active-Passive and Active-Active clustering setup?

552

---

How do I create a partition table in sql server?

488

---

---

How to connect php with different port numbers?

551

---

Write a code to select distinct records without using the DISTINCT keyword.

644

---

Can one drop a column from a table?

545

---

What is transact-sql ddl trigger?

628

---

How do I view a procedure in sql server?

533

---

What are data regions?

90

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

557

---

What is index, cluster index and nonclustered index?

512

---

What is best institute to Learn DotNET And SQL in chennai?

1686

---

What is "scheduled jobs" or "scheduled tasks"?

552

---