- Some times we may change the structure of a table or add new columns or delete some unused columns
- In this case, we need to find that particular atble used in our stored procedures
-write the following query to find
SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so on
sc.id=so.id WHERE sc.text LIKE '%TableName%'
- In this case, we need to find that particular atble used in our stored procedures
-write the following query to find
SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so on
sc.id=so.id WHERE sc.text LIKE '%TableName%'
No comments:
Post a Comment