KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Is there a way to find what stored procedures create an entry in a table. Say for example: Stored Procedure A inserts into Table A Stored Proceudre B Inserts into Table A Stored Procedure C Inserts into Table B I want to the query to return the name of Stored Procedure A and Stored Procedure B. Ive got this right now, but all it does is find Stored Procedures. I think it would be a good starting point to find the stored procedures. select schema_name(schema_id) as [schema], name from sys.procedures where name like '%Item%' and name like '%Create%' I am using Microsoft SQL 2008
Tags (comma-separated)
Save Edits
Cancel