You can set a stored procedure to be encrypted when you create it. Create
it with the below code

CREATE PROCEDURE storedprocedure WITH ENCRYPTION

Craig Berko
SQL Server DBA / Software Engineer
The MHA Group
(469) 759-8551

-----Original Message-----
From: George Mamacos
[mailto:mssqldba-ezmlmshield-x84733094.[Email address protected]
Sent: Tuesday, February 22, 2005 3:10 AM
To: LazyDBA Discussion
Subject: Loading encrypted procedures on SQL Server

Hi

I have developed some procedures and would like to protect the source code
from being easily copied.

Is there anyway of encrypting a procedure, prior to loading it on SQL
Server, and emailing it to a client, who will then load it themselves ?

Thanks.

George



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


This message has been scanned by the MHAGroup security appliance.

MS Sql Server LazyDBA home page