search deadlock

[hok1man]

Hi guys,

just wondering how to search deadlock in particular time in database and which query caused it?

I believe there's database log somewhere? can you help me how to find it?

do I need to be dbo_owner to execute it ?

Thanks guys,

 

[manmaria]

Did you try
select * from sa_conn_info()
or
select * from sa_locks()
or
select * from sa_conn_activity()