As of May 31, 2023, we have updated our Code of Conduct.
10 votes
Accepted

Is there a reliable way to check if a trigger being fired was the result of a DML action from another *specific* trigger?

You can use TRIGGER_NESTLEVEL with an objectid parameter IF TRIGGER_NESTLEVEL(OBJECT_ID(N'dbo.OtherTrigger', 'TR')) > 0 BEGIN -- do stuff END; The EVENTDATA() function is only relevant for DDL ...
Charlieface's user avatar
1 vote

Which Intelligent query processing features are available in the Enterprise Edition only?

Reference: Editions and supported features of SQL Server 2022 Enterprise Edition Only: Batch mode adaptive joins Batch mode memory grant feedback Intelligent Database: row mode memory grant feedback ...
SqlWorldWide's user avatar
  • 12.9k

Only top scored, non community-wiki answers of a minimum length are eligible