From "SQL Server Security", McGraw-Hill :

It is a symmetric encryption, the key based on a SHA hash of several
concatenated DB values, including the GUID and objectID from sysobjects.
Apparently you can decrypt it by reassemble the key from those values, if
you've admin privileges. See http://www.geocities.com/d0mn4r/dSQLSRVD.html


> -----Original Message-----
> From: Mark Dodson [mailto:Mark.[Email Address Removed]
> Sent: jeudi, 30. octobre 2003 16:01
> To: LazyDBA.com Discussion
> Subject: stored procedure encryption
>
>
>
> All,
> I am encrypting stored procedures for my SQL Server
> 2000 database. Does anyone have information on how/what
> Microsoft uses to create the encryption? Is the algorithm
> based on the hardware (MAC address, etc.)?
>
>
> Thanks,
>
> Mark
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Get today's cartoon: http://www.LazyDBA.com To unsubscribe,
> e-mail: mssqldba-[Email Address Removed] For additional
> commands, e-mail: mssqldba-[Email Address Removed]
MS Sql Server LazyDBA home page