Remove SQL comments

Question

Hi,

our stored procedures have developer comments and headers and as part of our deployment process we would like to remove these from the customer copy. Is there a method of achieving this within SQL Server 2005 or with another tool?

Answer 1

You may want to check this out:

Remove Comments from SQL Server Stored Procedures.

Note: this doesn't handle comments that start with --, which SQL Server allows. Otherwise I would inquire into having a developer write a short filter app that reads the text in via a stream, and then remove the comments that way. Or write it yourself.

Answer 2

Hi

Please check this link http://techcreeze.blogspot.com/2008/11/remove-comments-from-sql-server-stored.html

cheers

Answer 3

I assume you save your procedure definitions to a text or .sql file that you then version control. You could always use something like notepadd++ to find/replace the strings you want then commit them as a production/customer tag. This is not elegant, but an option. I don't know of any third party tools and my google searches returned the same result as the other posters posted.

Answer 4

I use an SQL tool called WinSQL (very handy, highly reccommended) that has an option to "Parse Comments Locally".

I don't use it much personally, but I have had it on accidentally when running my scripts that build my stored procs and it does clean them out of the proc source in the database. :-)

Even the free version has that option.

Ron

Answer 5

Don't know if it would suit, but you can use the WITH ENCRYPTION option to hide the entire contents. Do your end users need to see/modify any of the procedures?