SQL Utilities
| Item Name | Summary |
|---|---|
| MS SQL Server DB Search Stored Procedure (2009-01-21) | An MS SQL 2000/2005/2008 (and maybe SQL Server 7) T/SQL stored procedure to search in all UserDefined database tables across all columns (except VarBinary, Binary, Image and TimeStamp column types) for supplied data. Returns a cursor of all occurances, plus an additional cursor of all tables and columns where the data was found. |
| MS SQL Server DB Log File Shrinker (2008-10-15) | An MS SQL 2000/2005 stored procedure to shrink the Log File if there are no outstanding active transactions. |
| MS SQL "IN" Table Builder (2009-02-22) | An MS SQL 2000/2005/2008 T/SQL stored procedure to enable limitless building of a temporary cursor to be used with a SQL "IN" clause. The list is built up from iterations of passing a comma separated list to the stored procedure. |
All site contents copyright (c) HHHSoftware, 1997 - 2010 and Andy Strong unless otherwise stated |