>Is there a way in SQL Server Management Studio to find tables with a specific field name?
In SQL Server 2005 you could use:
SELECT OBJECT_NAME(Object_Id) AS TableName
FROM sys.COLUMNS
WHERE Name = 'YourColumnName AND OBJECTPROPERTY(Object_id, 'IsUserTable') = 1
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
