List Object in SQL Db - Specific Examples

The generic SQL found here can be tweaked to do almost anything


The following are more specific examples

-- This snippet searches for columns named like %product% 
SELECT
o.name AS TableName,c.*
FROM
sysobjects AS o
 INNER JOIN syscolumns AS c
  ON c.id = o.id
WHERE
(o.type = 'U' OR o.type = 'S')
AND c.name LIKE '%product%'

Deleting Restoring Databases

I keep forgetting this and it cost me time as the job runs forever and will not cancel.
With logshipping you sometimes need to delete a restoring database that has failed.
Remember that you need to uncheck the "delete backup and restore" checkbox