Shawn,

One way of doing it is to script the table definitions then search for the
column name in the script file.

Sang Nahm

-----Original Message-----
From: Shawn Smith [mailto:[Email Address Removed] Friday, July 12, 2002 8:49 AM
To: 'James Habjanetz'; [Email Address Removed] Querying all tables for a specific problematic column


I am having problems with a column in some of my tables. Does anyone have a
query that will search all tables for this column?
Thanks,

Shawn Smith
Database Administrator
Fort Worth Star-Telegram
817-390-7094
817-291-5240 cell
817-667-2757 pager
[Email Address Removed]MS Sql Server LazyDBA home page