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 to select true false based on column value in sql server?

1082

What is primary key and example?

997

Define magic tables in sql server?

1117

What is lock escalation? : sql server database administration

1198

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

1061

what method you can use to reduce the overhead of Reporting Services data sources?

268

Define outer join?

1047

What is surrogate key? : sql server analysis services, ssas

1160

What is the usage of the sign function?

1193

How to change the system date and time from SQL Plus Terminal ?

1272

What are basics of policy management?

1150

How to set database to be single_user in ms sql server?

1080

Explain about unique identifier data type in sql server?

976

How to modify existing triggers using "alter trigger"?

1065

What is the boxing and unboxing concept in .net?

976