<div>
What kind of file are you referring to?<br />
<br />
I suppose you're looking for the dependencies on that given field.<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/bb677315.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/bb677315.aspx</a>
</div>


What kind of file are you referring to?

I suppose you're looking for the dependencies on that given field.

http://msdn.microsoft.com/en-us/library/bb677315.aspx [http://msdn.microsoft.com/en-us/library/bb677315.aspx]

<div>
It is a table and yes I am looking for the dependencies
</div>


It is a table and yes I am looking for the dependencies

<div>
SSMS can get those for you<br />
<br />
<a href="http://www.devx.com/dbzone/Article/39892" rel="ugc">http://www.devx.com/dbzone/Article/39892</a>
</div>


SSMS can get those for you

http://www.devx.com/dbzone/Article/39892 [http://www.devx.com/dbzone/Article/39892]

<div>
This is good, but is there a way to drill down to a column in the table?
</div>


This is good, but is there a way to drill down to a column in the table?

<div>
Thanks there are only about 10 procedures that that use that column, so I can search those.
</div>


Thanks there are only about 10 procedures that that use that column, so I can search those.

<div>
<div class="content wysiwyg-content">
Is there a way to find all procedures that use a field in a file?<br />
<br />
The file is called carrier and I need to find all procedures that use a field called car_type2<br />

</div>
</div>


Is there a way to find all procedures that use a field in a file?

The file is called carrier and I need to find all procedures that use a field called car_type2


Fields in a file

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.