LISTING 1: Procedure to Determine Which Tables 
Might Contain Joined Elements

	/*Procedure for SQL Server 2000 and 7.0 */
CREATE PROCEDURE sp_fieldtab (@column_name nvarchar(384) = NULL)
AS
SELECT object_name(syscolumns.id) AS "Table Name" ,
rtrim(syscolumns.name) AS "Field 
Name",
CASE sysobjects.xtype WHEN 'u' THEN 'User Table' 
WHEN 'v' THEN 'View' END AS [Object 
Type] FROM syscolumns
INNER JOIN sysobjects ON syscolumns.id = sysobjects.id
WHERE syscolumns.name LIKE @column_name 
AND sysobjects.xtype IN ('u','v')