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 - create the temp db files dynamically

 Below script will  be help full for creating temp DB files for specified count  DECLARE @tempdbfilecount INT; DECLARE @tempdatadir ...