Thank this author by sharing:
By Vanitha G, 2010/01/01
TableName is a table name which you want to search and ColumnName name is the column you are seraching for. You may don't know the tbale name at this point use the second script for search the column name in all tables.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
