<div>
<a href="http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm" rel="ugc">http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm</a>
</div>


http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm [http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm]

<div>
thanks, I saw that on google, I was wondering if there was any way to do this without creating more tables. I should have been more clear
</div>


thanks, I saw that on google, I was wondering if there was any way to do this without creating more tables. I should have been more clear

<div>
No, its not that easy of a thing to do really....this is a really effective way to do it though.
</div>


No, its not that easy of a thing to do really....this is a really effective way to do it though.

<div>
ok, thanks, I will see if I can get the privilages to do so.
</div>


ok, thanks, I will see if I can get the privilages to do so.

<div>
<div class="content wysiwyg-content">
Hi I am wondering if there is a simple way to search all tables and all columns for a string of text in MS Sql Server 2005.?
</div>
</div>


Hi I am wondering if there is a simple way to search all tables and all columns for a string of text in MS Sql Server 2005.?

MS SQL Search all tables, all rows?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.