<div>
Nah.. &nbsp;SPROCS are just SQL Tables too.. &nbsp;They are just System tables though..<br />
<br />
<a href="http://blog.sqlauthority.com/2007/11/27/sql-server-2005-list-all-stored-procedure-in-database/" rel="ugc">http://blog.sqlauthority.com/2007/11/27/sql-server-2005-list-all-stored-procedure-in-database/</a><br />
<br />
HTH,<br />
<br />
Kent<br />

</div>


Nah..  SPROCS are just SQL Tables too..  They are just System tables though..

http://blog.sqlauthority.com/2007/11/27/sql-server-2005-list-all-stored-procedure-in-database/ [http://blog.sqlauthority.com/2007/11/27/sql-server-2005-list-all-stored-procedure-in-database/]

HTH,

Kent


<div>
To replace it though, you need to modify each sproc individually and do a search and replace from SSMS then execute the ALTER PROCEDURE statements.
</div>


To replace it though, you need to modify each sproc individually and do a search and replace from SSMS then execute the ALTER PROCEDURE statements.

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I need to find and update certain keywords in all stored procedures of MS SQL 2005 ( Std/Ent ).<br />
Is there a built-in or 3rd party tool to search for keywords?<br />
<br />
Thank you for your help
</div>
</div>


Hello,

I need to find and update certain keywords in all stored procedures of MS SQL 2005 ( Std/Ent ).
Is there a built-in or 3rd party tool to search for keywords?

Thank you for your help

Searching for a keyword in stored procedures of MS SQL 2005

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.

Microsoft SQL Server 2005

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.