Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Deadlock


Hi,

How we can detect deadlock from a database.

Rahul

Rahul,

You can use sql profiler to detect the deadlock, to resolve the dead lock
see the following link

http://www.sql-server-performance.com/deadlocks.asp
http://support.microsoft.com/kb/832524

VT
Knowledge is power, share it....
http://oneplace4sql.blogspot.com/

"Rahul" <verma.car@gmail.com> wrote in message

news:1181114850.247145.171690@i13g2000prf.googlegroups.com...

Hi Rahul,

Deadlocks can also be captured by issuing a dbcc command from Query
Analyser....

dbcc traceon (3604,1204,-1)

/* Please note trace flag 1204 returns the type of lock involved in the
deadlock and the current command that is issued by the connections
participating in the deadlock scenario. This flag also send this information
to the SQL Server error log. Trace flag 3604 returns the trace info to the
client while -1 indicates that you want to capture this deadlock information
for ALL connections */

Best Regards,
Andrew

Join the Tuning Revolution!
http://www.sqlbenchmarkpro.com/

"Rahul" <verma.car@gmail.com> wrote in message

news:1181114850.247145.171690@i13g2000prf.googlegroups.com...

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc