MS SQL query problem
| From: | Omar | Date: | Thu, 28 Aug 2003 17:26:54 +0000 |
| Subject: | MS SQL query problem | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-161066@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.