Click here to Skip to main content
15,881,938 members
Search within:


What is the Sql Query to find Stored procedure called for which all tables in Sql server 2005?
Please Sign up or sign in to vote.
0.00/5 (No votes)
What is the Sql Query to find Stored procedure called for which all tables in Sql server 2005?
Posted
Add a Solution

1 solution

SQL
----Option 1
SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE '%tablename%'
----Option 2
SELECT DISTINCT o.name, o.xtype
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE c.TEXT LIKE '%tablename%'
 
Share this answer
 
Posted
Comments
Rahul 105 12-Feb-14 0:09am    
Is it possible to get SPs with exact table name. If use LIKE (rOLES,rOLE_USER ETC RELATED SPS TO THOSE WILL COME)
SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT ='tablename'
But no Sp coming in above way.
Prasad Avunoori 12-Feb-14 0:34am    
I didn't get you.
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
How to find the list of unused stored procedures in SQL Server 2005?
How to convert the below query into stored procedure(MS SQL server) ?
convert MS SQL Stored Procedure to mysql Stored procedure
How to call stored procedure on other server
Create a stored procedure in SQL Server 2005
How to use sub query in stored procedure?
creating stored procedures in SQL server 2005
SQL Server stored procedure insert statement using dynamic table name
Stored procedure for sql server 2005
Sql stored procedure

Advertise
Privacy
Cookies
Terms of Use
Last Updated 11 Feb 2014
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web03 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900