[dba-SQLServer]How to suppress this warning message?

Billy Pang tuxedo_man at hotmail.com
Tue Aug 19 18:58:38 CDT 2003


Ok.  Thanks.
It is possible to monitor the occurance of this warning message from 
Profiler?

Thanks in advance,
Billy


>From: "Djabarov, Robert" <Robert.Djabarov at usaa.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: RE: [dba-SQLServer]How to suppress this warning message?
>Date: Tue, 19 Aug 2003 10:04:40 -0500
>
>If you're getting this error after a query (S/I/U/D), then identify the
>field that is being aggregated and do an ISNUL(..., 0) prior to
>aggregating it, like this: SUM(isnull(<your_field>, 0))
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Billy
>Pang
>Sent: Monday, August 18, 2003 6:04 PM
>To: dba-SQLServer at databaseadvisors.com
>Subject: [dba-SQLServer]How to suppress this warning message?
>
>
>"Warning: Null value is eliminated by an aggregate or other SET
>operation."
>
>Is there a way of suppressing this warning message?
>
>Thanks in advance,
>Billy
>
>_________________________________________________________________
>Help STOP SPAM with the new MSN 8 and get 2 months FREE*
>http://join.msn.com/?page=features/junkmail
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus



More information about the dba-SQLServer mailing list