Answer:
WITH ENCRYPTION keyword is used to encrypt the text of the Stored Procedure.
Once SPs are encrypted, the original text of the SP are not visible. User who has created the SP will need to save the text to be used to create SP somewhere safe to reuse it again or Users that have access to system tables or database files can retrieve the encrypted text.
Asked In: Many Interviews |
Alert Moderator