Snipplr

(SQL) SQL Delete Table if Exists - DaveChild

Thu, 11 Sep 2008 10:59:07 UTC

(SQL) SQL Write Disk Space to Table - DaveChild

Thu, 11 Sep 2008 10:58:32 UTC

This will run a bat file to get free space on a drive and write the results to a table. Use script at http://snipplr.com/view/8331/calculate-free-space-on-drive/ as FreeSpace.bat

(SQL) SQL Run Sanity Checks SP - DaveChild

Thu, 11 Sep 2008 10:52:59 UTC

Finds and runs all views that start with "sanity\_check". Writes number of rows returned by each view to sanity\_check\_results table for use later. Includes SQL to generate results table.

(SQL) SQL Obfuscate Credit Card Number - DaveChild

Thu, 11 Sep 2008 10:42:31 UTC

All but last 4 digits turned to *

(SQL) SQL Shrink Transaction Log - DaveChild

Thu, 11 Sep 2008 10:38:35 UTC

(SQL) SQL Rebuild Dev Database - DaveChild

Thu, 11 Sep 2008 10:37:01 UTC

This script should be run from the "master" database. It will destroy the dev copy of a database and restore from the live copy. Code slightly modified from original (linked).