Category Archives: SQL Server
Catching SQL Script Errors from an SQL Job
When structuring scripts to execute in production, I often wrap a transaction around the contents of my statements. This is done to keep data integrity in-tact and to make things simpler to support in the event that the execute fails. Here is a quick example:
Posted in SQL Server
Leave a comment