A beginner on a development server asked how to replace a column name in Multiple Stored Procedure code all together. Here is the quick way I suggest.
SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name – Part 2
Readers improved my script to find column used in stored procedure. Imran Mohammed shares newer scripts to search stored procedure for column name.
SQL SERVER – Find Column Used in Stored Procedure – Search Stored Procedure for Column Name
Want to drop a column? First find column used in stored procedure code. I share the T-SQL script that searches every stored procedure for a column name.
XACT_ABORT: Why a Half-Done Transaction Can Survive an Error
Use XACT_ABORT to prevent partial writes, inspect transaction state after an error, and build a TRY CATCH pattern with reliable rollback.
An Error Handling Template for Stored Procedures With THROW
Build an error handling template with XACT_ABORT, XACT_STATE, durable error logging, and THROW, then test a forced procedure failure.
Designing a Simple ETL Framework
An ETL framework in SQL Server needs a small set of configuration, run logs, restart checkpoints, and alerts that operators can trust.
SQL Error Actions: What SQL Server Does After an Error
SQL error actions decide what runs after an error in SQL Server. This post shows statement termination, scope abortion, batch termination, connection termination and XACT_ABORT, with real results from three small stored procedures. It also covers what each reaction does to an open transaction and how TRY…CATCH changes the outcome.