hi

Hi
I am new in the SQL server field and i tried to solve the problem of
deadlocking.
Please help me in resolving the deadlock in step by step process.
Thank you
ABiAbi
Since you have not mentioend what is the version are you using?
http://blogs.msdn.com/bartd/archive.../09/747119.aspx
"Abi" <abi.chapagai@.gmail.com> wrote in message
news:1159853389.087757.64370@.m7g2000cwm.googlegroups.com...
> Hi
> I am new in the SQL server field and i tried to solve the problem of
> deadlocking.
> Please help me in resolving the deadlock in step by step process.
>
> Thank you
> ABi
>|||Boy that is a pretty vanilla request there. The topic of deadlock
resolution can go from database design to proper indexing to locking levels,
etc.
I think you would best learn from the hundreds of articles and websites that
already cover this topic on the Internet.
"Abi" <abi.chapagai@.gmail.com> wrote in message
news:1159853389.087757.64370@.m7g2000cwm.googlegroups.com...
> Hi
> I am new in the SQL server field and i tried to solve the problem of
> deadlocking.
> Please help me in resolving the deadlock in step by step process.
>
> Thank you
> ABi
>|||Hi,
Go thru this URL. This say the methods to troubleshoot deadlocking.
http://www.sql-server-performance.com/deadlocks.asp
Thanks
Hari
"Abi" <abi.chapagai@.gmail.com> wrote in message
news:1159853389.087757.64370@.m7g2000cwm.googlegroups.com...
> Hi
> I am new in the SQL server field and i tried to solve the problem of
> deadlocking.
> Please help me in resolving the deadlock in step by step process.
>
> Thank you
> ABi
>|||sp_who2
"Abi" <abi.chapagai@.gmail.com> wrote in message
news:1159853389.087757.64370@.m7g2000cwm.googlegroups.com...
> Hi
> I am new in the SQL server field and i tried to solve the problem of
> deadlocking.
> Please help me in resolving the deadlock in step by step process.
>
> Thank you
> ABi
>|||There are actually a couple better than sp_who and sp_who2 at:
http://www.sqlservercentral.com/Scr...20&categoryid=1
I've used the new sp_who3 and sp_what (my favorite). Check 'em out - very
nice.
"Mike C#" <xyz@.xyz.com> wrote in message
news:krFUg.778$iS5.121@.newsfe11.lga...
> sp_who2
>
> "Abi" <abi.chapagai@.gmail.com> wrote in message
> news:1159853389.087757.64370@.m7g2000cwm.googlegroups.com...
>