SQL Server Interview Questions

Submit Interview Question with Answer | Search Questions | Interview Home | Exclusive Interview Home |

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

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.

Found interesting? Add this to:

| More

Write Response

Navigate to: Submit Interview Questions Next Question >>: What is user-defined functions in SQL Server? ... << Previous Question: What is Distributed Queries in SQL Server? ... Random Questions: Random Interview Questions Help: If for some reason you are getting the same question by clicking Next Question or Previous Question, Try clicking Categories link above.

Related interview questions
What is user-defined functions in SQL Server? ... What is user-defined data type in SQL Server? ... What is the use of bit data type and what kind of data is stored into it? ... What is blocking in SQL Server? ... How to write a method in a class and build as .dll ... How to declare a method in an Interface? ... How to add auto increment column in the DataTable? ... How to create a column in the DataTable? ... How to add a new row in DataTable? ... What is the difference WCF and Web services? ... What are various ways of hosting WCF Services? ... What are the main components of WCF? ... More ...

General Notice: If you found plagiarised (copied) contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.

Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 9/3/2010 4:29:01 AM

SQL Server Interview Questions

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

Related interview questions