October 22, 2005 at 3:41 pm
Hi,
I appreciate if somebody can help me out withthe following warning occuring in one of the job.This job uses like 50 stored procedures and Can any body tell me how to capture information about which stored procedure or sql statement causing this warning.Can I use profiler someway?
Warning: Null value is eliminated by an aggregate or other SET
operation.
I don't want to switch off ANSI_WARNING.
Thanks,
Sree
Thanks,
SR
October 24, 2005 at 11:01 am
Sree-
Option I:
Turn on profiler to trace all errors and stored procedures. Check the proc name where the error appears
Option II:
Go step by step in the job for each procedure ..in query analyzer until you hit the "set" error. (this is the long way)
Option III: update all procedures with error code to print out errors and more importantly the procedures name when it fails so you can at least narrow down the sp name.
Hope this helps.
Jonas Irwin
October 24, 2005 at 11:12 am
Sree-
Option I:
Turn on profiler to trace all errors and stored procs.
Option II:
Go step by step in the job for each proc ..in query analyzer until you hit the "set" error.
Option III: update all procs with error code to spit out errors and more importantly the procerdure name when it fails so you can at least narrow the sp name.
Hope this helps.
Jonas Irwin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply