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 ...
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
...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
sql-server × 33019sql-server-2012 × 3268
sql-server-2008-r2 × 2625
t-sql × 2416
sql-server-2008 × 2351
sql-server-2014 × 2288
sql-server-2016 × 2152
performance × 2037
availability-groups × 1158
backup × 1144
index × 926
query-performance × 922
ssms × 860
database-design × 847
replication × 829
sql-server-2005 × 818
sql-server-2017 × 788
stored-procedures × 737
restore × 725
execution-plan × 694
sql-server-2019 × 672
permissions × 669
ssis × 663
security × 574
transaction-log × 562