How to configure the logs

How do you configure the logs in SQL Server? Currently, all I see is my
backup processes. I'm trying to investigate a deadlock and I need much
more detail in the logging. I know I've done it before, but I can't
seem to find it now.Rick
Check out DBCC TRACEON in the BOL
"Rick Harrison" <rick@.knowware.com> wrote in message
news:40867FEE.3050505@.knowware.com...
> How do you configure the logs in SQL Server? Currently, all I see is my
> backup processes. I'm trying to investigate a deadlock and I need much
> more detail in the logging. I know I've done it before, but I can't
> seem to find it now.
>|||Hi,
To add on to previous post,
you can also you SQL profiler-- In the event class use the event Deadlock.
Otherwise like Uri pointed out use
DBCC TRACEON(1204)
This will send the deadlock information to SQL server error log.
Thanks
Hari
MCDBA
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e1CYZq6JEHA.2576@.TK2MSFTNGP12.phx.gbl...
> Rick
> Check out DBCC TRACEON in the BOL
> "Rick Harrison" <rick@.knowware.com> wrote in message
> news:40867FEE.3050505@.knowware.com...
> > How do you configure the logs in SQL Server? Currently, all I see is my
> > backup processes. I'm trying to investigate a deadlock and I need much
> > more detail in the logging. I know I've done it before, but I can't
> > seem to find it now.
> >
>