Link to home
Create AccountLog in
Avatar of niceguy971
niceguy971

asked on

Sql Server 2008--How to identify all stored procedures referencing a particular table MyTableCustomer

What would be the best way ( easiest way ) to  identify all stored procedures referencing a particular table MyTableCustomer

in Sql Server 2008?

Thanks
SOLUTION
Avatar of Tapan Pattanaik
Tapan Pattanaik
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of Pratima
Pratima
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of niceguy971
niceguy971

ASKER

Hi Taran and Pratima,

Scenario: SP belongs to Database MyDatabaseOne--> this SP uses table from ANOTHER Database

MyDatabaseTHREE.dbo.MyTableCustomer.

How do you handle this scenario??

Looks like your approach will Not work.
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks!