<div>
You will have to build a T-SQL Script using the OBJECT_DEFINITION() function that retrieves the Stored Procedure text. &nbsp;Once you have it in a text file you can do whatever you need before re-running.
</div>


You will have to build a T-SQL Script using the OBJECT_DEFINITION() function that retrieves the Stored Procedure text.  Once you have it in a text file you can do whatever you need before re-running.

<div>
That way I would need to do it manually (remove the comments), wouldn't I?<br />
I was thinking more along the lines of something automatized, that detects every line that starts with -- and delete it from there..
</div>


That way I would need to do it manually (remove the comments), wouldn't I?
I was thinking more along the lines of something automatized, that detects every line that starts with -- and delete it from there..

<div>
Exactly what I was looking for, thanks.
</div>


<div>
<div class="content wysiwyg-content">
As the title suggests I need to delete about 5-10 lines of comments on each procedure, but there are just TOO MANY of them..<br />
Is there ANY way to automatize this task?<br />
<br />
Thanks.
</div>
</div>


As the title suggests I need to delete about 5-10 lines of comments on each procedure, but there are just TOO MANY of them..
Is there ANY way to automatize this task?

Thanks.

How to automatically delete all comments on thousands of procedures on a database?

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 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.

Microsoft SQL Server 2008

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.