Here's a quick script to run it against all of your tables. I've still got to figure out your syntax a bit better 😉

Doug

CREATE PROCEDURE [dbo].[ExamineAllTables]

AS

BEGIN

SET NOCOUNT ON

DECLARE

@TableCntINT,

@CurrentTableINT,

@TableSYSNAME

CREATE TABLE #TableListing

(

[IndexListingID]INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,

[TableName]SYSNAME COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL

)

INSERT INTO #TableListing( [TableName] )

SELECT [Name]

FROM sys.tables

ORDER BY [Name]

SELECT @TableCnt = @@ROWCOUNT, @CurrentTable = 1

WHILE @CurRentTable <= @TableCnt

BEGIN

SELECT @Table = TableName

FROM #TableListing

WHERE [IndexListingID] = @CurrentTable

EXECUTE dbo.ShowColumnUsage @Table

SET @CurrentTable = @CurrentTable + 1

END

END