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

Microsoft SQL Server 2008Microsoft SQL Server

Last Comment

niceguy971

8/22/2022 - Mon

SOLUTION

Tapan Pattanaik

4/23/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

SOLUTION

Pratima

4/24/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

niceguy971

4/24/2015

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

Vitor Montalvão

4/24/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

niceguy971