SAVE TRANSACTION sets a marker inside an open transaction. You can roll back to it and keep the earlier work. This post tests it on SQL Server 2025. It shows why a nested BEGIN TRAN can’t do the same and what XACT_STATE() returns after an error.
SQL SERVER – Easiest Way to Copy All Stored Procedure Definitions
Object Explorer Details helps copy procedure definitions through SSMS scripting. I select the procedures and review the generated script before execution.
SQL SERVER – Stored Procedure Timing and Cached Measurements
SET STATISTICS TIME reports CPU and elapsed execution time for Stored Procedures. A customer wanted to measure a run without adding statements manually.
SQL SERVER – Get Column Names
I Get Column names using a schema-qualified table and a defined column order. The four methods use corrected filters.
Hide Code in SSMS – SQL in Sixty Seconds #154
I have received so many emails from all of you to create a video on the topic of SQL SERVER – Hide Code in SSMS. Here is the video on the topic.
Hide Procedure Code in SSMS: What WITH ENCRYPTION Covers
To hide procedure code, create the procedure WITH ENCRYPTION. A demo shows what the clause blocks: the text, the definition and the plan. It also shows the ALTER trap that unhides a procedure, and why this is obfuscation and not security.
SQL SERVER – Delayed Durability and Flushing Log Files
Flushing with sys.sp_flush_log hardens preceding committed delayed-durable transactions in the current database. I use delayed durability only with an accepted tradeoff.