I too disagree with the answer, but for another reason:

Without a table definition, there is no way of knowing that the BusinessEntityID column is a primary key column (not everyone...

(at the time of this reply)

Gotta love the amount of points the OP/creator has! 🙂

PS: This looks really awesome; will be checking it out soon!

• This reply was modified 3 years, 1 month ago by  dbaninja.

A bit late to the party here, but...

You can look into implementing Ola Hallengren's maintenance solution (https://ola.hallengren.com/) - it works beautifully.

• This reply was modified 5 years, 2 months ago by  dbaninja. Reason: Incorrect information

Thanks for the post. I agree with you as I have run into this exact scenario numerous times.

One caveat though to keep in mind:

The commented out ROLLBACK / COMMIT sections...

I have successfully used SQL's native auditing features. The only set-back I found was the location for the data (you can only choose "File", Windows "Security Log" or Windows ...