var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Set Ansi_nulls
When I use OPENROWSET OR OPENQUERY in a Stored Procedure I get an error:
"Heterogeneous quieries 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."
I don't remember what I have to do to get around this. I tried placing:
SET ANSI_NULLS OFF
SET ANSI_WARNINGS OFF
Before and after the Create Procudure... line but I can't remember how to correctly use this. Any suggestions?
Last edited by asahi; 12-06-05 at 13:18.
Reason: Answered in another post in the past by another user