If You want to find out A particular Table From Database used which Stored Procedure in DB. You can Get Stored ProcedureName with Respected Schema Class.
For Example,
If you Use AdventureWorks Database. Now You want to Find out person.Person Table Used Which Stored Procedure among Database. You can use Following Commands in Sql Server.
Use AdventureWorks
GO
SELECT * FROM sys.dm_sql_referencing_entities('person.Person', 'OBJECT')
No comments:
Post a Comment