Posted by rshivaraman on 05/16/07 12:42

Hi All :

A couple of tables have been identified to be deleted. My job is to
find if it is at all used.
On searching the web, i found a proc to search for a string within all
databases in a server.
using system sproc : sp_msforeachdb

it searches for a string in
views, sprocs, functions, check constraints, defaults, foreign key,
scalar function, inlined tablefunction, primary key, 'Replication
filter stored procedure, System table, Table function, Trigger, 'User
table, 'UNIQUE constraint''Extended stored procedure'

So it is pretty extensive. But i dont think it is covering the code
within execsqltasks in DTS, and tsql code within JOB STEPS. Those are
the two more places where code exists in my server.

If any of you have done so in the past, do let me know if there is a
system stored proc or code that you have written, to do the same

thanks
RS

Link to the above procedure

http://www.sql-server-performance.com/ak_find_sql_server_database_objects.asp

• Next in forum: Re: create constraint error
• Prev in forum: create constraint error
• Thread view: Search for a table/string within job steps, dts, database, stored procedures etc

[Reply to this message]