InstantForum.NET v4.1.4SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 08 Nov 2009 09:14:36 GMT20http://www.sqlservercentral.com/Forums/Topic527158-146-1.aspxwe can use sp_depends 'table_name' as well to see which objects are using the particular table.Tasawar hussainNetsol technologiesMon, 07 Jul 2008 20:46:50 GMTmalik.tasawarhttp://www.sqlservercentral.com/Forums/Topic527158-146-1.aspxThis SP will find the desired text as shown in the procedure and can be used in SQL 2000 and 2005 - note it will find the watchword even if it is in a comment within the SP or FunctionCREATE PROCEDURE UDP_FindWordsInaSP@Watchword varchar(50) AS SELECT distinct 'type' = case type when 'FN' then 'Scalar function' when 'IF' then 'Inlined table-function' when 'P' then 'Stored procedure' when 'TF' then 'Table function' when 'TR' then 'Trigger' when 'V' then 'View' end, o.[name], watchword = @WatchwordFROM dbo.sysobjects o (NOLOCK) JOIN dbo.syscomments c (NOLOCK) ON o.id = c.id WHERE charindex(lower(@Watchword),lower(text)) <> 0 and o.type in ('FN', 'IF', 'P', 'TF', 'TR', 'V') and o.name NOT LIKE 'dt%' and o.name NOT LIKe 'sys%' and o.name NOT LIKE 'UDP_FindWordsInaSP' ORDER BY type, o.[name]-- run as UDP_FindWordsInaSP 'your table name''Thu, 03 Jul 2008 12:49:18 GMTbitbucket-25253http://www.sqlservercentral.com/Forums/Topic527158-146-1.aspxhere is a query i use frequently when taking over databases I didn't create:select b.table_name, a.name, a.type_descfrom information_schema.tables b left join sys.procedures a on OBJECT_DEFINITION(a.OBJECT_ID) like '%'+b.table_name+'%'where b.table_type = 'BASE TABLE' and b.table_name in ('TABLENAME1','TABLENAME2')order by b.table_name ascPut the list of table names you are looking for in the stored procedures.This just does a search for that keyword. If you called your table 'select' or 'from', this won't be much help :)Wed, 02 Jul 2008 12:00:39 GMTJamieXhttp://www.sqlservercentral.com/Forums/Topic527158-146-1.aspxCheck the SQL Server 2005 Default TRACE File... it might show you something... if you know the time... of Happenings.Wed, 02 Jul 2008 10:41:26 GMTMani Singhhttp://www.sqlservercentral.com/Forums/Topic527158-146-1.aspxRun a trace on the server is one way. Check the transaction log is the other.Wed, 02 Jul 2008 07:05:16 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic527158-146-1.aspxHi,Is there any means to know by which SP is a particular table getting modified. (in Both SQL 2000 and 2K5).Wed, 02 Jul 2008 04:57:16 GMTsachin.ranka