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

How will you monitor replication latency in transactional replication? : sql server replication

1086

State the difference between local and global temporary tables?

1047

can we have a nested transaction? : Sql server database administration

991

What is “asynchronous” communication in sql server service broker?

958

Please explain what is “asynchronous” communication in sql server service broker?

878

what purpose does the model database serve? : Sql server database administration

919

Explain features and concepts of analysis services?

925

Explain system views?

1020

Tell me when is the update_statistics command used?

1015

How can I create a new template for import ? : sql server management studio

1022

What are the different types of collation sensitivity?

1054

List the different types of collation sensitivities in sql server?

972

Explain what are the restrictions while creating batches in sql server?

1020

How to return the top 5 rows from a select query in ms sql server?

1070

Explain transaction server auto commit?

984