I am trying to update a table on server
The table has a tigger on update that update
another table on a linked server
For the simplicty all connection on the linked server are mapped to 'sa'
In the trigger I am first setting the
SET ANSI_DEFAULTS ON
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
AND ONLY THEN issue an update query on the linked server.
When I am Trying updating the table having the trigger using Query Analyzer with the connection paramtes ANSI_NULLS check boxs unmarked (To simulate an application I have)
I am getting the "Hetrogeneous queries riquire ANSI NULL..." Error
why ?
Please Help !!!