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.



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

SQLDBA- Deadlock graph query

  Dead lock graph query DECLARE @xelfilepath NVARCHAR(260) SELECT @xelfilepath = dosdlc.path FROM sys.dm_os_server_diagnostics_log_configura...