sql server new users: Is there anything in SQL Server Management Studio that will allow you to
find text within tables, stored procs and views...not the data itself but
within the data definition language? For example, I need to find all of the
database objects that are using link servers.

Thank you very much!

I'm not sure what you mean by tables if you just want the
DDL but for views, triggers, functions, stored procedures,
etc you could try querying the catalog view sys.sql_modules.
The definition column has the DDL text for the objects. So
something like -
select *
from sys.sql_modules
where definition like '%YourLinkedServer%'

-Sue

On Mon, 22 May 2006 10:36:30 -0600, "G. Ray Giacalone"
[quoted text, click to view]