Wednesday, 5 April 2017

What are the limitations of triggers in Sql Server?

 These are the limitations of triggers in  Sql server

1. We can not pass the parameters for triggers  like Stores procedure , function etc....
2. can not perform COMMIT or ROLLBACK.



-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

SQLDBA : export or download SSIS packages

As part of the SSIS package upgrade planning, we need to ensure that the latest source code for all deployed packages is available in our so...