Edit: removed

If you want better chances of an answer, post your question using insert statements for your data and post desired results in a readable way.

Example:

Sample data:

DECLARE @mytable TABLE(

EmpCode...

GilaMonster (4/15/2015)

---

If you wrap that in a transaction, then you're removing the point of running batched deletes in a loop, you may as well remove the while and the top...

You need to wrap everything in a try/catch and handle the transaction accordingly.

You could use something similar to the stored procedure code template you can find here: http://spaghettidba.com/2011/07/08/my-stored-procedure-code-template/

This is how...

It won't, unless you go beyond available disk space in the mirror server of course.

Usually, the tool I use for this kind of tasks is a script for rs.exe.

Here's a detailed description of the script: https://msdn.microsoft.com/en-us/library/dn531017.aspx

Pfft! Amateur. Somebody once told...

Removed

Duplicate post. Replies here please: http://www.sqlservercentral.com/Forums/FindPost1676771.aspx

You can start by reading this excellent ebook on the subject:

https://www.red-gate.com/community/books/accidental-dba

Troubleshooting is a complex topic, no single answer applies. Read the book and you'll find a detailed and simple...

Usually you want to catch errors in each stored procedure and re-throw them to calling procedures. I published my stored proceedure code template here: http://spaghettidba.com/2011/07/08/my-stored-procedure-code-template/

Hope this helps

It's not possible directly. You have some options:

1) Create another job (B) that checks the outcome of the first job (A) every 30 minutes and sends and email only when...

Alessandro, thank you for your thorough and accurate article. I look forward to reading more from you.

So it looks like it's blocked by another SPID.

If you don't have Adam Machanic sp_WhoIsActive, download it (http://sqlblog.com/files/folders/beta/entry42453.aspx) and run it with these parameters:

EXEC sp_WhoIsActive @get_outer_command = 1, @get_plans =...

What is the wait type you see for the blocking SPIDs?