Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Remove SQL comments

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?

like image 217
Damien McGivern Avatar asked Nov 23 '25 21:11

Damien McGivern


1 Answers

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?

like image 66
MikeW Avatar answered Nov 25 '25 10:11

MikeW