<div>
Use this query to find whether a Stored Procedure is used inside some other Stored procedure.<br />
<br />
Replace the search string with your actual Stored Procedure name<br />
<br />
Raj<br />

<pre><code id="code-1099346">SELECT ROUTINE_NAME, ROUTINE_DEFINITION 
FROM INFORMATION_SCHEMA.ROUTINES 
WHERE ROUTINE_TYPE='PROCEDURE' and
ROUTINE_DEFINITION LIKE '%YourStoredProcedure%'
</code></pre>
</div>


Use this query to find whether a Stored Procedure is used inside some other Stored procedure.

Replace the search string with your actual Stored Procedure name

Raj


SELECT ROUTINE_NAME, ROUTINE_DEFINITION 
FROM INFORMATION_SCHEMA.ROUTINES 
WHERE ROUTINE_TYPE='PROCEDURE' and
ROUTINE_DEFINITION LIKE '%YourStoredProcedure%'


<div>
This is one approach to find table 'table_name' in an entire server:<br />
<br />
You can, of course, remove the else statement if you don't want to be bothered with all the places it doesn't exist.<br />

<pre><code id="code-1099567">sp_msforeachdb '
use ? 
if exists(
	select * from information_schema.tables
	where table_name = ''table_name''
	)
	print ''Table table_name exists in ?''
else
	print ''Table table_name does not exist in ?''
'
</code></pre>
</div>


This is one approach to find table 'table_name' in an entire server:

You can, of course, remove the else statement if you don't want to be bothered with all the places it doesn't exist.


sp_msforeachdb '
use ? 
if exists(
	select * from information_schema.tables
	where table_name = ''table_name''
	)
	print ''Table table_name exists in ?''
else
	print ''Table table_name does not exist in ?''
'


<div>
<div class="content wysiwyg-content">
Hi Experts, <br />
I would need help with a query that can find if a stored procedure is being used in another stored procedure &nbsp;or any DTS packages for a given server.<br />
And aslo would need help with query to find a table in a given server not just find in a database.<br />
Thanks!
</div>
</div>


Hi Experts, 
I would need help with a query that can find if a stored procedure is being used in another stored procedure  or any DTS packages for a given server.
And aslo would need help with query to find a table in a given server not just find in a database.
Thanks!

Query to find if a stored procedure is being used anywhere else and also to find table in a server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.