Equivalent of user_source table (as in oracle) in SQL Server.

• Sudha Thenappan

  SSC Veteran

  Points: 229

  More actions

  March 7, 2005 at 4:29 am

  #185479

  Hi

  In SQL Server Stored procedures, I need to know what are the procedures that make use of a particular field of a table. Is there any easy way to find out ? In oracle we can find out from the user_source table. Please let me know it there is an easy way.

• CK Bhatia

  Say Hey Kid

  Points: 679

  More actions

  March 7, 2005 at 8:09 am

  #545734

  You can query the syscomments table as follows

  select distinct object_name(id) from syscomments with (nolock)

  where ctext like '%Your_Column_Name%'

  However, if you have the same column name in multiple tables, you may not end up getting the desired result. In that case, you could search for the specific table instead of the column name.

   

  ---

  I feel the need - the need for speed

  CK Bhatia