Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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

Is This Answer Correct ?    33 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which are the two editions in which SQL Azure database available?

119


What is bcnf normalization form?

1120


What is the new security features added in sql server 2016? : sql server security

1120


What is global temp table?

1000


How do I clean up sql server transaction log?

1071


Name three of the features managed by the surface area configuration tool? : sql server security

996


What is enhanced database mirroring in sql server 2008?

973


What are views in ms sql server?

1088


How important do you consider cursors or while loops for a transactional database?

971


What is parameterized reports in ssrs ?

149


How to choose all records from the table?

1072


What should be the fill factor for indexes created on tables? : sql server database administration

1142


What are locks in sql?

986


What is the difference between upgrade and migration in sql server?

1098


What are the different authentication modes in sql server? How can it be changed?

1095