Dead Lock replication in Sql server

sunil19 has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Dead Lock replication in Sql server by Corion (Patriarch) on Jun 30, 2017 at 11:02 UTC
I have some questions since your question is vague and we cannot give you a good answer without understanding the question. Do you have code that reproduces the database deadlock? Do you get a database deadlock while replicating the database to another server? Is your problem that you need to replicate a specific database deadlock situation? Do you have problems using Exception::Class::TryCatch? If you have problems using Exception::Class::TryCatch, please show us the code you have already written and tell us how it fails for you.	[reply]
Re^2: Dead Lock replication in Sql server by sunil19 (Initiate) on Jun 30, 2017 at 11:09 UTC
Hello Corion, I need a simple code for replicating deadlock in sql server.After replicating the deadlock issue i need code to fix the deadlock issue by using the Exception::Class::TryCatch. Thanks	[reply]
Re^3: Dead Lock replication in Sql server by Corion (Patriarch) on Jun 30, 2017 at 11:11 UTC
If you need code to replicate a deadlock in Microsoft SQL Server, I think you are wrong here. Creating a deadlock in a database is not a Perl problem, it is more an SQL problem. Once you have the SQL to create the deadlock, use DBI to send the SQL to the server. Then fix the issue by using Exception::Class::TryCatch.	[reply]
Re^4: Dead Lock replication in Sql server by sunil19 (Initiate) on Jun 30, 2017 at 11:50 UTC
Re^5: Dead Lock replication in Sql server by Eily (Monsignor) on Jun 30, 2017 at 12:29 UTC
Some notes below your chosen depth have not been shown here
Re^5: Dead Lock replication in Sql server by AnomalousMonk (Archbishop) on Jun 30, 2017 at 15:47 UTC
Re^4: Dead Lock replication in Sql server by sunil19 (Initiate) on Jun 30, 2017 at 11:17 UTC
Re^5: Dead Lock replication in Sql server by Corion (Patriarch) on Jun 30, 2017 at 11:32 UTC
Re^5: Dead Lock replication in Sql server by marto (Cardinal) on Jun 30, 2017 at 11:18 UTC
Re^3: Dead Lock replication in Sql server by marto (Cardinal) on Jun 30, 2017 at 11:16 UTC
Welcome, this isnt' a code writing or job outsourcing forum. Please take your time to familiarise yourself, PerlMonks for the Absolute Beginner/How do I post a question effectively?. The documentation for Exception::Class::TryCatch and DBI should be your first port of call, you'll likely know how to create a deadlock in MS SQL Server (I've no idea, I'd never use it), failing that speak to your DBA, a sane websearch or reading the documentation will likely help.	[reply]
Re: Dead Lock replication in Sql server by locked_user sundialsvc4 (Abbot) on Jun 30, 2017 at 14:51 UTC
Does this series of transactions, in fact, deadlock? If it does, then you have two choices for how to handle it. DBI provides a `RaiseError` option, normally not set, which will throw an exception whenever any error occurs. If you are particularly interested in error #1205, then you can test for that result-code and throw an exception yourself.