MS SQL query problem
| From: | Omar | Date: | Thu, 28 Aug 2003 17:28:04 +0000 |
| Subject: | MS SQL query problem | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-21271@lists.php.net to get a copy of this message | ||
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.