Friday 15 December 2017

To Get All Stored Procedure List which used particular Table


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

Youtube blocked hack play youtube video from embedded url

Youtube introduced new feature for playing video in own website or third party application using embed feature. Youtube blocked in some of ...