Adaptive Server versions 11.5 and later allow you to verify the existence of source text, and encrypt the text if you choose. Use these commands when you are working with source text:
sp_checkresource – verifies that source text is present in syscomments for each compiled object.
sp_hidetext – encrypts the source text of a compiled object in the syscomments table to prevent casual viewing.
sp_helptext – displays the source text if it is present in syscomments, or notifies you of missing source text.
dbcc checkcatalog – notifies you of missing source text.
