crackyourinterview.com


To improves our performance please Like Share Subscribe(Will boost us)

Difference in between Triggers and Event Notifications?
Question Posted on 12 Apr 2023Home >> DataBase >> sql questions >> Difference in between Triggers and Event Notifications?

Difference in between Triggers and Event Notifications?
Below are the 4 main difference in between Triggers and Event Notifications:-
0
0

NumberBase of differenceTriggersEvent Notifications
1CodesIn triggers we can run T-SQL or CLR codes.In Event notification we can not run any codes.
2Processes ServerTriggers must be processed on local servers.When we say about the Event Notification it can be processed on remote servers.
3ScopeTriggers are processed synchronously within the scope of transactionsThey are processed asynchronously, not within the scope of transactions
4EventsWhen we say about the respond in Triggers it will respond to both DML and DLL events. Event notification respond to DDL evenets and a subset of SQL trace events.


.


Most Visited Questions:-

Deep Learning Questions Answers
Below are the different Deep Leaning Questions and answer a More...

Continuous Integration Questions Answers
Below are the 20 odd questions for CI or Continuous Integra More...

Derived relationships in Association Rule Mining are represented in the form of __________.
Derived relationships in Association Rule Mining are repres More...

What is Gulpjs and some multiple choice questions on Gulp
Gulpjs is an open source whihc helps in building Javascript More...

Microservices Architecture Questions Answers
Below are the different questions on Microservices Architec More...




Other Important Questions

Define N in nvarchar and in nchar?

difference between drop and truncate command

difference between procedure and function

different types of databases in sql

Difference Between Update Lock and Exclusive Lock






@2014-2022 Crackyourinterview (All rights reserved)
Privacy Policy - Disclaimer - Sitemap