Monthly Archives: August 2007

Norton Ghost 12.0: My latest favorite tool

Just used Norton Ghost to upgrade/replace a hard drive that was in the early stages of failing–it had had a few intermittent blue screen/reboots: This was a HP Pavilion zv5000 laptop with a 60GB drive and XP Home. Event Viewer showed several things of note around the reboot times:Got a bug check: 0x0000007a (0xc03dd9a4, 0xc000000e, […]

Norton Ghost 12.0: My latest favorite tool

Just used Norton Ghost to upgrade/replace a hard drive that was in the early stages of failing–it had had a few intermittent blue screen/reboots: This was a HP Pavilion zv5000 laptop with a 60GB drive and XP Home. Event Viewer showed several things of note around the reboot times:Got a bug check: 0x0000007a (0xc03dd9a4, 0xc000000e, […]

Further refined Find Text in Column Name

Now returns table (or function which returns a table) and column name. CREATE FUNCTION Find_Text_In_Column_Name (@StringToSearch varchar(100))RETURNS @fColumnNames TABLE (tablename sysname, colname sysname)ASBEGIN SET @StringToSEarch = ‘%’ + @StringToSearch + ‘%’ INSERT @fColumnNames SELECT DISTINCT SO.NAME, SC.NAME FROM syscolumns SC (NOLOCK)INNER JOIN sysobjects SO (NOLOCK) ON SC.id = SO.id WHERE SC.NAME LIKE @StringToSearch ORDER BY […]

Functions to find text in column names and in stored procedures and function definitions

Implemented in SQL Server:This function finds a text string in a stored procedure or function definition: CREATE FUNCTION Find_Text_In_SP_or_FN (@StringToSearch varchar(100))RETURNS @fNames TABLE (name sysname)ASBEGIN SET @StringToSearch = ‘%’ + @StringToSearch +’%’ INSERT @fNames SELECT DISTINCT SO.Name FROM sysobjects SO (NOLOCK) INNER JOIN syscomments SC (NOLOCK) on SO.ID = SC.ID AND (SO.Type = ‘P’ OR […]