SQL Server 2008 includes three general types of triggers: 1)DML triggers

How many types of TRIGGERS are there in MS SQL Server?

Question Posted / yugal

Answer Posted / yugal

SQL Server 2008 includes three general types of triggers:

1)DML triggers
2)DDL triggers
3)Logon triggers.

Is This Answer Correct ?

26 Yes

5 No

Please Help Members By Posting Answers For Below Questions

List types of tables in SQL Azure?

102

What is merge?

565

What is the difference between local and global temporary tables?

577

Why main is user defined function?

563

What is precedence constraint?

543

What is the cartesian product of the table?

544

How do I find the sql server version?

516

Can you explain various data region available in ssrs with their use?

544

Call by value and call by reference in procedure and function, with NOCOPY.

833

A trigger can reference objects outside the current database? State true or false.

550

What are the disadvantages of using querystrings to send data from one page to another?

582

What is a heap?

615

What is local temp table?

551

What are the aggregate and scalar functions?

521

What does it mean to invest in the index?

505