problems using linked server.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maria Isabel Guzman - 25 Jul 2008 01:19 GMT

Hi, I am using a store procedure that calls another three store
procedures. Two of them use linked server.

When I run this two store procedures on the query analizer it works
fine, but when I run the store procedures from the application displays
the error:

Msg 7405, Level 16, State 1, Server SERVER1, Procedure SP1, Line 77
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 already set the ansi_nulls and ansi_warnings On, but it doesn't work.

Do someone have any idea what should i check or change to make the store
procedures work from the aplication

Reply to this Message

Dan Guzman - 25 Jul 2008 02:07 GMT

> I already set the ansi_nulls and ansi_warnings On, but it doesn't work.

The ANSI_NULLS (and QUOTED_IDENTIFIER) session settings in effect when a
stored procedure is created are remembered at execute time. Try creating
the procedures with ANSI_NULLS ON.

Signature

Hope this helps.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

> Hi, I am using a store procedure that calls another three store
> procedures. Two of them use linked server.
[quoted text clipped - 16 lines]
>
> *** Sent via Developersdex http://www.developersdex.com ***

Reply to this Message