.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
‹
›
Home
View web version
No comments:
Post a Comment