RE: Encrypted Stored Proc

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Alejandro Mesa (AlejandroMesa_at_discussions.microsoft.com)
Date: 11/09/04 

Date: Tue, 9 Nov 2004 08:14:05 -0800

use northwind
go

create procedure dbo.usp_proc1
with encryption
as
set nocount on
return 0
go

declare @objname sysname

set @objname = 'usp_proc1'

select
        encrypted
from
        syscomments
where
        [id] = object_id(@objname)
go

drop procedure dbo.usp_proc1
go

AMB

"L Gonzales" wrote:

> Is there an easy way to identify how many stored procs are
> encrypted in a database?
>
> TIA.
>

Relevant Pages

  • Re: SQLServer 2005 Encrypt/Decrypt
    ... Declare @Etext varbinary ... seems to work but the decryption isn’t. ... ENCRYPTION BY PASSWORD = 'pentagon' ...
    (microsoft.public.sqlserver.programming)
  • Re: Need to call C++ function from VB.NET
    ... The function just does some encryption. ... > Declare Ansi Sub AIEncrypt Lib "your.dll" ... > ByVal sReadable As String, ... >> void WINAPI AIEncrypt(LPSTR sReadable, ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Poor Mans Genericity?
    ... >> If you write a function that encrypts a file, you obviously declare ... > encryption (which it often is, provided you strip off any compression headers). ... But this is not unique for checked exceptions, ...
    (comp.lang.java.programmer)
  • RE: Best way to Encrypt a feild in a production db?
    ... I think you'll have to change stored procs where inserts/updates/delets ... But question comes down to is how strong encryption you want. ... It is also possible to use symmetric encryption with a pass phrase as the ... DECLARE @encryptedstuff NVARCHAR ...
    (microsoft.public.sqlserver.security)
  • Re:Data Encryption
    ... SQL Server has 2 undocumented password encryption function ... by which you can encrypt and decrypt a string. ... declare @ret int ...
    (microsoft.public.sqlserver.security)