<div>
Thanks! &nbsp;Worked great.
</div>


<div>
 hmm -if it does not work for you (see example below) - for me it worked:<br />
--------------------------<wbr />----------<wbr />----------<wbr />----<br />
EXEC sp_MSForEachDB 'IF ''?'' NOT IN (''master'', ''model'', ''msdb'', ''tempdb'')<br />
&nbsp; select ''[?]'''<br />
-----------<br />
Try:<br />
<br />
EXEC master..sp_MSForeachdb '<br />
USE [?]<br />
IF ''?'' &lt;&gt;&nbsp;''master'' AND ''?'' &lt;&gt;&nbsp;''model'' AND ''?'' &lt;&gt;&nbsp;''msdb'' AND ''?'' &lt;&gt;&nbsp;''tempdb''<br />
BEGIN<br />
&nbsp; &nbsp; &nbsp; &nbsp; SELECT ''?'' <br />
&nbsp; &nbsp; &nbsp; &nbsp;END'<br />

</div>


<div>
<div class="content wysiwyg-content">
I am trying to run a stored procedure, sp_MSForEachDB in SQL but I want to exclude the system databases.<br />
<br />
I have tried:<br />
<br />
EXEC sp_MSForEachDB 'IF ''?'' Not In (''TEMPDB'', ''master'', ''model'', ''msdb'') use ? select top 10 * from tablename'<br />
<br />
But it is still searching the system databases for a tablename that does not exist.<br />
<br />
What am I doing something wrong?
</div>
</div>


I am trying to run a stored procedure, sp_MSForEachDB in SQL but I want to exclude the system databases.

I have tried:

EXEC sp_MSForEachDB 'IF ''?'' Not In (''TEMPDB'', ''master'', ''model'', ''msdb'') use ? select top 10 * from tablename'

But it is still searching the system databases for a tablename that does not exist.

What am I doing something wrong?

How can I exlude system databases from a stored procedure.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.