Hide Implementation Details of Stored Procedures
You can hide the implementation details of your stored procedures from end users of the application using WITH ENCRYPTION option. ENCRYPTION indicates that SQL Server encrypts the syscomments table entry