Use these commands to verify the existence of source text and encrypt the source text of a compiled object.
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.