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

SQLDBA- SQL Server Wait Events

  To solve slowness of SQL Server database, you should find which wait events exists in the database. You can find wait events of database w...