Re: Encryptin stored procedures

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 10/28/04

  • Next message: Jasper Smith: "Re: Control over creation of procs & views owned by dbo" 
    Date: Wed, 27 Oct 2004 23:20:19 +0100

    Search google for "decrypt SQL stored procedure"

    Not sure what you mean by the second part. Specifying WITH ENCRYPTION for
    your CREATE PROCEDURE script will generate an encrypted stored procedure but
    the script itself is plain text. 

    -- 
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Gaby" <msdn@rmya.com.ar> wrote in message 
news:OcjhQ5CvEHA.944@TK2MSFTNGP11.phx.gbl...
> Is there any way to generate a script of an encrypted stored procedure?
>
>
>
> I supose that itsn't, so, is there are any way to encrypt a script so that 
> I
> can generate a encrypted stored prodcedure?
>
>
  • Next message: Jasper Smith: "Re: Control over creation of procs & views owned by dbo"

    Relevant Pages

    • Re: composite key question
      ... Each time you do an insert SQL ... it's probably not a stored procedure. ... queries to perform slower, however. ... Seeing as how that script you sent was not a stored proc, ...
      (microsoft.public.sqlserver.programming)
    • Re: Newbie - Stored Procedures/ASP Question
      ... I tried shortening the Stored Procedure, and using the script from your ... The SQL Stored Procedure is below. ...
      (microsoft.public.inetserver.asp.db)
    • Re: Help with SQL 2005 and Sourcesafe 6
      ... I understand where you're coming from but if you open up the .sql script ... stored procedure in the database that it belongs to. ...
      (microsoft.public.sqlserver.tools)
    • Re: Stored Procedures
      ... Andrew J. Kelly SQL MVP ... Clients means all sorts of Stored procedure we do using " WITH ENCYPTION " ... >> I initially thought the "with encryption" option would do ... >> at client sites--or pay for them. ...
      (microsoft.public.sqlserver.security)
    • Re: Anything that you find in SQL object scripts, you can also find them in system tables?
      ... > in the text sql scripts, are those also located in the system tables? ... you should not really script your databases more than at ... SQL Server, but this is not likely to happen this decade. ... > Can i rename an object name for example an Index name, a Stored Procedure ...
      (comp.databases.ms-sqlserver)