How to encrypt the storeprocess In SqlServer2000 ?

How to encrypt the storeprocess In SqlServer2000 ,
so other people Can not see the SP Source in bussiness SoftWare ..
any Detail about this ?
the better ,give me some document on the web !
Thanks a lot !
FireCrow Studio
Kylin Garden
EMail:gaotianpu@.gmail.com
ICQ:156134382
hi,
Kylin wrote:
> How to encrypt the storeprocess In SqlServer2000 ,
> so other people Can not see the SP Source in bussiness SoftWare ..
> any Detail about this ?
> the better ,give me some document on the web !
> Thanks a lot !
SQL Server 2000/MSDE provides the CREATE PROCEDURE ... WITH ENCRYPTION (
http://msdn.microsoft.com/library/de...reate_4hk5.asp )
clause you can use to encrypt the text of your stored procedures..
if you go this way, please keep your procedures in some kind of source code
control so that you maintain the original procedure's text code available..
just a note... the SQL Server encryption algorith has been broken in the
past, so this protection is not fully secure, even if for standard users
will be enought..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Don't fool yourself into thinking they are "secure" if you do this though.
If you search on Google for "sql server decryption", you will quickly find
several free tools for decrypting anything encrypted in SQL Server with that
function.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3e69ciF1dun2U1@.individual.net...
> hi,
> Kylin wrote:
> SQL Server 2000/MSDE provides the CREATE PROCEDURE ... WITH ENCRYPTION (
>
http://msdn.microsoft.com/library/de...reate_4hk5.asp )
> clause you can use to encrypt the text of your stored procedures..
> if you go this way, please keep your procedures in some kind of source
code
> control so that you maintain the original procedure's text code
available..
> just a note... the SQL Server encryption algorith has been broken in the
> past, so this protection is not fully secure, even if for standard users
> will be enought..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi,
Derrick Leggett wrote:
> Don't fool yourself into thinking they are "secure" if you do this
> though.
> If you search on Google for "sql server decryption", you will quickly
> find
> several free tools for decrypting anything encrypted in SQL Server
> with that
> function.
>
did you read my post... I wrote:[vbcol=seagreen]
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply