Adaptive Server allows 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.
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.
