Goal: How to find a table on your server: SET NOCOUNT ON CREATE TABLE myTable99(TABLE_CATALOG sysname, TABLE_SCHEMA sysname, TABLE_NAME sysname, TABLE_TYPE varchar(50)) GO CREATE PROC usp_FindMyTable (@TABLE_NAME sysname = null) AS SET NOCOUNT ON TRUNCATE TABLE myTable99 IF @TABLE_NAME IS NULL BEGIN PRINT 'No Table to look for. Please supply a tabke name. Like: ' + CHAR(13) + ' EXEC usp_FindMyTable Orders' GOTO usp_FindMyTable_Exit END DECLARE @MAX_dbname sysname, @dbname sysname, @sql varchar(8000) ......