You are a database developer at an independent software vendor. You create stored procedures
that contain proprietary code.
You need to protect the code from being viewed by your customers.
Which stored procedure option should you use?
A.
ENCRYPTBYKEY
B.
ENCRYPTION
C.
ENCRYPTBYPASSPHRASE
D.
ENCRYPTBYCERT
Explanation:
http://technet.microsoft.com/en-us/library/bb510663.aspx
http://technet.microsoft.com/en-us/library/ms174361.aspx
http://msdn.microsoft.com/en-us/library/ms187926.aspx
http://technet.microsoft.com/en-us/library/ms190357.aspx
http://technet.microsoft.com/en-us/library/ms188061.aspx
?
B
ENCRYPTION: Indicates that SQL Server will convert the original text of the CREATE PROCEDURE statement to an obfuscated format. The output of the obfuscation is not directly visible in any of the catalog views in SQL Server.
ENCRYPTBYKEY: It is a Cryptographic Function, not a procedure option.
B
B.
CREATE PROCEDURE sp_name
WITH ENCRYPTION
AS