.Net Special Support
This blogs provides .Net tips and practical solutions
Thursday, 24 May 2012
Get all store procedure that references with perticular tables
SELECT DISTINCT o.name, o.xtype FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE c.TEXT LIKE '%tblname%'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment