quote:

---

Originally posted by Bustaz Kool

I don't know of a tool that does that does this. We make use of a GREP like tool from RedGate named SQL Search that searches through the object definitions for a specific string (e.g., "Employee"). You would need to know where to apply your searches. The tool was free but was also targeted for commercialization so it may be charged for now.

=======================================
A couple of months in the laboratory can save a couple of hours in the library. -Frank H. Westheimer, chemistry professor (1912-2007)

---

quote:

---

Originally posted by vision.v1

Hi,

How can i find out list of stored procedure, functions which will refer to a particular table.

I would like to find out the list of stored procedures & functions not only in the current database but also which are present is another databases

For eg. if we write the following:

sp_depends Employee

It will display name and type of the object only in the current database, but i want the list which are present in another database

please give suggestions

Thanks

Hello Friend,
Kindly try below query
SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%TableName%'

---

quote:

---

Originally posted by urzsuresh

quote:

---

Originally posted by vision.v1

Hi,

How can i find out list of stored procedure, functions which will refer to a particular table.

I would like to find out the list of stored procedures & functions not only in the current database but also which are present is another databases

For eg. if we write the following:

sp_depends Employee

It will display name and type of the object only in the current database, but i want the list which are present in another database

please give suggestions

Thanks

Hello Friend,
Kindly try below query
SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%TableName%'

---

Suri

---