Re: Select Statement: Join vs Inner Select

From: SriSamp (ssampath_at_sct.co.in)
Date: 04/01/04


Date: Thu, 1 Apr 2004 10:08:26 +0530

The procedure creation supports a WITH ENCRYPTION option that can used to
encrypt the contents of the stored procedure.

-- 
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"Jason" <jasonserv@hotmail.com> wrote in message
news:e4ylRw4FEHA.3064@tk2msftngp13.phx.gbl...
> >Finally, you can always "encrypt" your stored
> > procedures so that the source is never visible in the server and only
you
> > have a copy of it on your local machine (or source control software).
>
> Can you elaborate more on the encryption of sp? I wonder SQL Server could
> really understand encrypted sp.
>
> Regards,
> Jason
>
>


Relevant Pages

  • Re: Security violation by my host
    ... WITH ENCRYPTION ... This will encrypt the SP in the database so if anyone opens it will be ... my stored procedure codes and tables structures. ... skillful SQL Server admin can access what he wants in a DB like this. ...
    (microsoft.public.sqlserver.security)
  • Some analysis of Microsoft SQL Server 2000 stored procedure encryption
    ... It's well known that the stored procedure encryption in SQL Server ... algorithm used and what its weaknesses are. ... CREATE PROCEDURE bob ...
    (Bugtraq)
  • Re: Questions about WITH ENCRYPTION
    ... There were 3rd party tools available that could decrypt on earlier versions. ... But I think the encryption is stronger on 2k. ... Because it wont work unless you have the clear text of the stored procedure. ...
    (microsoft.public.sqlserver.security)
  • Re: Encryptin stored procedures
    ... Search google for "decrypt SQL stored procedure" ... Specifying WITH ENCRYPTION for ... the script itself is plain text. ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)
  • Re: VB6 ADO Sql2000 Extended Stored Procedure
    ... > I now wish to call this Stored Procedure from my Vb 6 Client. ... > do the encryption the only data that is correctly inserted into my table ... The encrypted fields show all Null ... > It appears that ADO can't handle calls to extended Stored Procedures. ...
    (microsoft.public.vb.database.ado)