Hi All,
Use the WITH ENCRYPTION Option in SQL Server when ever you want to hide the business- logic
in Views / Procedures / Functions. (Specially in Client sites when ever we use procedures).
This is part of the application code, therefore please pay more attention to that.
Note : that you will not be able to regenerate the scripts from the server, if you use this option.
This is a sample
CREATE VIEW TEST
WITH ENCRYPTION
AS SELECT 'TEST' AS TI
No comments:
Post a Comment