This should be relativly easy. I have set up linked SQL instances and have a stored procedure on one that inserts a row in the other. When running the SP i get the ANSI_NULLS and ANSI_WARNINGS error for the connection.
I need someone who can look at this and resolve the issue. I cannot modify the connection string only the stored procedure.
* * *This broadcast message was sent to all bidders on Tuesday Nov 24, 2009 3:15:11 PM:
I attached the stored procedure.