One quick way that comes to mind would be to make a small executable (or
console) application in .NET, and embed the DDL's (using the ENCRYPTION
in the DDL as normal of course) as embedded resources.

Simply have the console/executable take the required connection
parameters as startup parameters, connect to the db using the supplied
values, execute the DDL's (one by one, within a single transaction etc
as you please/need).

Of course, the encrypted text in syscomments IS possible to extract, and
so is the embedded resource, but it does require some efforts, and in
that provides some security of course.

That's just a small idea, maybe someone else have a better one :-)

HTH,

Fridthjof-G Eriksen



-----Original Message-----
From: George Mamacos
[mailto:mssqldba-ezmlmshield-x84733094.[Email address protected]
Sent: Tuesday, February 22, 2005 10: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]


MS Sql Server LazyDBA home page