-
Running stored procedure for linked server
Hi,
I'm using SQL Server 2000. My query runs fine through Query Analyzer. But if the same query is called thru a stored procedure it gives the following error inspite of setting the ANSI_NULLS and ANSI_WARNINGS on both the servers;
"Server: Msg 7405, Level 16, State 1, Line 1
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."
Can anybody please help me on this.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|