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 ...
- 10k
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
...
- 12.9k
Only top scored, non community-wiki answers of a minimum length are eligible