Heterogeneous Query and ANSI_NULLS/_WARNINGS

I'm trying to create a stored proc that creates a link to a remote server and executes
other stored procedures as needed. Each of the sub-procs will be running Heterogeneous Queries.
I'm having trouble creating these sub-procs, I get the error message that states
Heterogeneous Queries require ANSINULLS and ANSIWARNINGS be set...
I have the remote server linked when I try to create the procs.
I've tried SET ANSI_NULLS and _WARNINGS with no effect so I'm assuming these need to be set on the linked server.
I tried EXEC sp_serveroption 'sqlSOLOMON', 'ANSI_NULLS', 'ON'
EXEC sp_serveroption 'sqlSOLOMON', 'ANSI_WARNINGS', 'ON'
but got an 'invalid options' error.

Does this need to be set as server defaults on each server or can I make these settings in a usp?
After the procs are created and I create the link at runtime can I expect some problems?

Any suggestions/links would be greatly appreciated.
I am also an Application developer who gets roped into this DBA stuff as needed. I'm the closest they have here
to a DBA and I cant find any decent answers in 'books on-line' or my books on-desk.

'Ack!'
troy

Troy,
The settings need to be set when you create your stored
procedures - not in the stored procedures but for the
connection creating the stored procedures - so that the
stored procedures are created with these settings. Something
along the lines of:
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO
CREATE PROCEDURE YourStoredProc...etc.

-Sue

On Fri, 9 Apr 2004 13:06:06 -0700, "Troy"
wrote:

 >I'm trying to create a stored proc that creates a link to a remote server and executes
 >other stored procedures as needed. Each of the sub-procs will be running Heterogeneous Queries.
 >I'm having trouble creating these sub-procs, I get the error message that states
 > Heterogeneous Queries require ANSINULLS and ANSIWARNINGS be set...
 >I have the remote server linked when I try to create the procs.
 >I've tried SET ANSI_NULLS and _WARNINGS with no effect so I'm assuming these need to be set on the linked server.
 >I tried EXEC sp_serveroption 'sqlSOLOMON', 'ANSI_NULLS', 'ON'
 > EXEC sp_serveroption 'sqlSOLOMON', 'ANSI_WARNINGS', 'ON'
 >but got an 'invalid options' error.
 >
 >Does this need to be set as server defaults on each server or can I make these settings in a usp?
 >After the procs are created and I create the link at runtime can I expect some problems?
 >
 >Any suggestions/links would be greatly appreciated.
 >I am also an Application developer who gets roped into this DBA stuff as needed. I'm the closest they have here
 >to a DBA and I cant find any decent answers in 'books on-line' or my books on-desk.
 >
 >'Ack!'
 >troy