Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning List out all the procedures which uses a particualr table. RE: List out all the procedures which uses a particualr table.

  • April 27, 2009 at 5:53 am

    #984275

    select object_name(object_id) from sys.sql_modules where definition like '%tablename%' should do it.

    You can modify the search condition any other way that suits your needs.

    "Keep Trying"