Post reply

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

  • 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.

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply