Unanswered: Linked servers and problem with ANSI_NULLS and ANSI_WARNINGS
I've configured linked server from MS SQL 7.0 to Oracle 9.2. Next I've created trigger on table in MS SQL Database. Application which I'm using inserts data to this table and should to run this trigger. But after insertion of data I can see following messages in my logs:
SQL Server User Error: 7405, State 1, Severity: 16, Message: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.
....and trigger doesn't do nothing ...
I red that I should use special settings for connection via linked servers.
SET ANSI_NULLS on
SET ANSI_WARNINGS on
...but I have found this in examples about procedures not about triggers. So my question is : is it possible to solve this problem if I use triggers ? And if it's possible, how can I do this ?