Just like it says -- "enable these options and then reissue your query"
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON

-----Original Message-----
From: Todd Harness
[mailto:mssqldba-ezmlmshield-x2472172.[Email address protected]
Sent: Wednesday, June 30, 2004 1:40 PM
To: LazyDBA Discussion
Subject: ANSI NULLS AND ANSI WARNINGS


Hi All,

I am trying to run this query and keep facing the following error. Can
anyone help me with what I need to to do to make this work.

TIA
Todd

Select top 1 * FROM OPENDATASOURCE('SQLOLEDB','Data
Source=Myserver;User
ID=Mylogin;Password=Mypassword').master.dbo.sysobjects


Server: Msg 7405, Level 16, State 1, Line 2
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.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page