Hi Guest

MobileUser

1 HomePage 1 Jobs 1 WalkIn 1Articles  

Cat Exam

 :) Latest Topic
AJAX
VB.NET
SQL Query
UDDI
CLASS
JavaScript Questions
SharePoint Interview
SilverLight
WCF
general knowledge
 ASP.NET
 :) Hot Jobs
 
 :) Latest Articles


  

 


Difference in between Triggers and Event Notifications?
Question Posted on 12 Apr 2023

Home >> 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.


 
 Input Your Comments Or suggestions(If Any)
 Name
 Email(optional)
 Comments


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






 
Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions
PHP | Biztalk | Testing | SAP | HR |