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.

MS Sql Server LazyDBA home page