May 6, 2004 at 10:13 am
I am trying to address the ANSI warning message with "SET ANSI_WARNINGS OFF"
Warning: Null value is eliminated by an aggregate
or other SET operation.
How ever I get this message:
Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection.
I am indeed using linked server in that query. The only problem this warning causing is that my job out put file has lot of these messages and I was wondering if there is any way I can turn these messages off in a linked server environment.
May 7, 2004 at 1:01 pm
Use ISNULL or CASE to replace those NULL values with 0 or '' (empty string) in your aggregate functions.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy