SQLServerCentral.com Scripts tagged transactions

Open transactions on a database

Wed, 30 Jan 2013 07:00:00 UT

This script will show you all open transactions from any query windows.

Tue, 20 Mar 2012 06:00:00 UT

Significance of TABLE VARIABLES in error handling and error logging.

Wed, 29 Dec 2010 07:00:00 UT

Simple script formatting the date and naming a backup file path for a t-log and restoring those logs.

Thu, 22 Jul 2010 06:00:00 UT

Ever happened that your custom log got rolled back and you were left with nothing but an error_message()? Try to log into a table variable.

Mon, 27 Jun 2011 06:00:00 UT

Creates a view/select statement for given transactional table using foreign key info. Great for ETL extraction or History table routine.

Mon, 16 Aug 2010 06:00:00 UT

Sequential transaction log restore