| Author |
How can we capture each sql statement error on the DB
|
|
| Tom Celica 2002-12-19, 8:23 pm |
| Our CTO would like to capture each sql execution error that occurs on our
DB. Note, that no human users access this DB only machine users and DB jobs.
He would like to know:
1. The name of the user
2. the sql statement that errors
3. The name of the Stored Procedure that executes the failing sql statement.
Is it posible to capture this much information about sql statement errors.
Ideally he would like to capture that info in a table or a log file.
Is it posible to capture the condition of sql statement erroring?
Thanks
-tom
| |
| Oleg Deshin 2002-12-19, 9:23 pm |
| Hi
This is exactly that SQL Profiler does
Oleg.
"Tom Celica" <jhonda@juno.com> wrote in message
news:9WuM9.1334$QQ.78893119@newssvr13.news.prodigy.com...
> Our CTO would like to capture each sql execution error that occurs on our
> DB. Note, that no human users access this DB only machine users and DB
jobs.
>
> He would like to know:
> 1. The name of the user
> 2. the sql statement that errors
> 3. The name of the Stored Procedure that executes the failing sql
statement.
>
> Is it posible to capture this much information about sql statement errors.
> Ideally he would like to capture that info in a table or a log file.
>
> Is it posible to capture the condition of sql statement erroring?
>
> Thanks
> -tom
>
>
| |
| Tom Celica 2002-12-19, 10:23 pm |
| Oke Doke, I'll take a look at the sql profiler
Thanks
"Oleg Deshin" <olegusan@yahoo.com> wrote in message
news:OK1KtX9pCHA.1888@TK2MSFTNGP09...
> Hi
>
> This is exactly that SQL Profiler does
>
> Oleg.
>
> "Tom Celica" <jhonda@juno.com> wrote in message
> news:9WuM9.1334$QQ.78893119@newssvr13.news.prodigy.com...
> > Our CTO would like to capture each sql execution error that occurs on
our
> > DB. Note, that no human users access this DB only machine users and DB
> jobs.
> >
> > He would like to know:
> > 1. The name of the user
> > 2. the sql statement that errors
> > 3. The name of the Stored Procedure that executes the failing sql
> statement.
> >
> > Is it posible to capture this much information about sql statement
errors.
> > Ideally he would like to capture that info in a table or a log file.
> >
> > Is it posible to capture the condition of sql statement erroring?
> >
> > Thanks
> > -tom
> >
> >
>
>
|
|
|
|