ANSI warnings and linked server

• mssql_rules

  SSCrazy

  Points: 2783

  More actions

  May 6, 2004 at 10:13 am

  #85503

  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.

• angel-117050

  Mr or Mrs. 500

  Points: 597

  More actions

  May 7, 2004 at 1:01 pm

  #505707

  Use ISNULL or CASE to replace those NULL values with 0 or '' (empty string) in your aggregate functions.