What is the use of Keyword WITH ENCRYPTION keyword in SQL Server?

 Posted by Poster on 6/17/2009 | Category: Sql Server Interview questions | Views: 5078

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 

Comments or Responses

Login to post response