I have couple of question regarding SQL Server:
1. How can I detect deadlock sitation in SQL Server and can I resolve them automatically?
2. We run SQL jobs on a definite schedule. Is there a way I can create a report of selected SQL jobs, time taken by them to complete execution, failure if any, and number of records affected.