<div>
Is the field named '90000'?<br />
<br />
Giannis
</div>


<div>
The value of the field is '90000'
</div>


<div>
This will be a nasty one, but here is a solution<br />
<br />
<a href="http://blogs.thesitedoctor.co.uk/tim/2010/02/19/Search+Every+Table+And+Field+In+A+SQL+Server+Database+Updated.aspx" rel="ugc">http://blogs.thesitedoctor<wbr />.co.uk/tim<wbr />/2010/02/1<wbr />9/Search+E<wbr />very+Table<wbr />+And+Field<wbr />+In+A+SQL+<wbr />Server+Dat<wbr />abase+Upda<wbr />ted.aspx</a><br />
<br />
Giannis
</div>


This will be a nasty one, but here is a solution

http://blogs.thesitedoctor.co.uk/tim/2010/02/19/Search+Every+Table+And+Field+In+A+SQL+Server+Database+Updated.aspx [http://blogs.thesitedoctor.co.uk/tim/2010/02/19/Search+Every+Table+And+Field+In+A+SQL+Server+Database+Updated.aspx]

Giannis

<div>
Here is the solution.<br />
<br />
<a href="http://beyondrelational.com/modules/2/blogs/78/posts/11138/how-to-search-a-string-value-in-all-columns-in-the-table-and-in-all-tables-in-the-database.aspx" rel="ugc">http://beyondrelational.com/modules/2/blogs/78/posts/11138/how-to-search-a-string-value-in-all-columns-in-the-table-and-in-all-tables-in-the-database.aspx</a>
</div>


Here is the solution.

http://beyondrelational.com/modules/2/blogs/78/posts/11138/how-to-search-a-string-value-in-all-columns-in-the-table-and-in-all-tables-in-the-database.aspx [http://beyondrelational.com/modules/2/blogs/78/posts/11138/how-to-search-a-string-value-in-all-columns-in-the-table-and-in-all-tables-in-the-database.aspx]

<div>
<div class="content wysiwyg-content">
I need to find 1 field '90000' in all tables within a database .<br />
<br />
Any suggestions would be really appreciated
</div>
</div>


I need to find 1 field '90000' in all tables within a database .

Any suggestions would be really appreciated

Looking for a field within an entire Database..

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.