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

What is the use of sql profiler in sql server 2012?

882

What are the limitations/drawbacks or ssrs 2008 r2?

139

How to delete all rows with truncate table statement in ms sql server?

992

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

970

Explain about thread and memory management process of SQL?

964

What are joins in sql and what are the different types of joins?

1002

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1030

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

986

What are ddl triggers and types of ddl trigger?

1032

What is the use of tempdb? What values does it hold?

1061

What are dml (data manipulation language) statements in ms sql server?

977

Explain what is sql server english query?

1038

What is transaction server distributed transaction?

1041

What are logical database components? : SQL Server Architecture

1025

What is triggers in ms sql server?

1106