This is a discussion on MS SQL query problem within the PHP General forums, part of the PHP Programming Forums category; I have a sql query, something like SELECT x FROM server1.table WHERE x IN (SELECT x FROM server2.table) ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
I have a sql query, something like
SELECT x FROM server1.table WHERE x IN (SELECT x FROM server2.table) I get a warning when loading the page. This is the warning: Warning: MS SQL message: 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. (severity 16) I donīt know what to do, where to look... Thanks for any help. |