Ansi_nulls & warnings -- sql server connect

mai
8/14/2003 11:58:04 AM

Hi there!

DO you any idea why this error comes up? What should i do?
"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."

I did try in my script by setting these options on but i
still got the error. What i did was:
alter database databasename
set ansi_nulls ON
set ansi_warnings ON

Sue Hoegemeier
8/14/2003 1:47:47 PM

These need to be executed before running the query, e.g.
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO
<your sql statements>

If this is stored procedure, you need to create the stored
procedure with these setting, e.g.
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO
CREATE PROCEDURE YourStoredProc...etc.

-Sue

On Thu, 14 Aug 2003 11:58:04 -0700, "mai"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server connect

sql server connect : Ansi_nulls & warnings