Distributed Query

Results 1 to 2 of 2

Thread: Distributed Query

  1. #1
    Join Date
    Dec 1969

    Default Distributed Query

    I have set up a linked server and named it TESTDATA. I then created a stored procedure on the server that points to the linked server. The codes is as follows:<BR><BR>CREATE PROCEDURE sp_Test<BR>AS<BR>SELECT<BR>*<BR>FROM <BR>TESTDATA.ORDER_DATA.dbo.Orders<BR>GO<BR><BR>Wh en I try and apply the sproc, I get an error stating that "Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection."<BR><BR>How do I do this? Thanks in advance.<BR><BR>Gary

  2. #2
    Join Date
    Dec 1969

    Default RE: Distributed Query

    &nbsp;<BR>CREATE PROCEDURE sp_Test<BR>AS<BR>Set Ansi_nulls on<BR>Set Ansi_warnings on<BR>SELECT<BR>*<BR>FROM<BR>TESTDATA.ORDER_DATA.d bo.Orders<BR>GO<BR><BR><BR>But then really you should have discovered this if you had read the BOL<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts