Is trigger fired implicitely?
Answers were Sorted based on User's Feedback
Answer / jay vardhan singh
Yes,
Trigger cannot be fired explicitly.We cannot call trigger .
It fires automatically on event.
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / sivasankardoss
No, Trigger cannot be fired implicitely. Only a DML
statement can invoke a trigger.
Is This Answer Correct ? | 1 Yes | 6 No |
How do I delete a sql server database?
What are “unrepeatable reads”?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What are the fixed server level roles? : sql server security
What is merge?
Can we perform backup restore operation on tempdb? : sql server database administration
What are the extra roles available in msdb? : sql server security
Does a server store data?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
if no size is defined while creating the database, what size will the database have? : Sql server administration
How can I create a plain-text flat file from SQL Server as input to another application?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?