error ANSI_NULLS anD ANSI_WARNINGS

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

error ANSI_NULLS anD ANSI_WARNINGS

Author

Topic

dave-mad
Starting Member

6 Posts

Posted - 2004-11-12 : 10:45:26

Hi, when i try to execute this code:

UPDATE A SET A.Nome = B.Nome FROM CAMP_TeleSales_ANAGRAFICA A, P1...Agenti B where A.Id = B.Codice and B.Action = 1

the server returns the following error :

Error 7405, level 16, state 1, row 1
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.

Before the Execute command i've put the code

SET ANSI_NULLS ON
SET ANSI_WARNINGS OFF

but it seems that SQL Server don't cares about. Anyone knows how to avoid the problem??

dave-mad
Starting Member

6 Posts

Posted - 2004-11-12 : 11:53:29

Problem solved using the QA to create the procedure

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources