Sometimes you don't want others to know the source code in your stored procedures, functions, views, etc. in SQL Server.
In this case, you can include WITH ENCRYPTION followed by CREATE PROCEDURE, CREATE VIEW, CREATE FUNCTION, etc. like that:
CREATE PROCEDURE ProcedureName
WITH ENCRYPTION
CREATE VIEW ViewName
WITH ENCRYPTION
CREATE PROCEDURE FunctionName
WITH ENCRYPTION
Friday, November 28, 2008
How to encrypt your stored procedure, view, function, etc in SQL Server
at 9:20 PM
Labels: SQL Server, SQL Server 2000, SQL Server 2005
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment