SQL Server Encryption Question

From: Mark (Mark_at_discussions.microsoft.com)
Date: 05/12/05

  • Next message: Mark: "RE: Transfer SQL 6.5 logins and passwords" 
    Date: Thu, 12 May 2005 09:36:03 -0700

    Environment: SQL 2000 SP3a

    I need to understand the encryption procedure in MS SQL 2000. I couldn't
    find anything online about Stored Procedure Encryption.

    I want to know is what internally happens when you create a Store Procedure
    or View or UDF using WITH ENCRYPTION Clause.

    Does SQL Server call a DLL to encrypt the text or EXE from BIN directory
    under separate thread? What happens to the compiled program of Encrypted
    procedure?
    Does SQL Server still need an object in Sysobjects when the procedure is
    already encrypted. If so, Why? What algorithm SQL Server uses to encrypt the
    procedure?

    TIA

  • Next message: Mark: "RE: Transfer SQL 6.5 logins and passwords"

    Relevant Pages

    • Re: MS Access linked tables SQL Server
      ... Protocol Encryption selection so that all connections to the SQL Server are ...
      (microsoft.public.sqlserver.security)
    • Re: SSIS as part of scheduled job fails
      ... Can't even open the package. ... Deloyed to SQL store. ... Microsoft SQL Server Management Studio ... Encryption not supported on SQL Server. ...
      (microsoft.public.sqlserver.dts)
    • Re: SSIS as part of scheduled job fails
      ... Can't even open the package. ... Microsoft SQL Server Management Studio ... Encryption not supported on SQL Server. ...
      (microsoft.public.sqlserver.dts)
    • Re: Encryption
      ... I realize that almost any encryption scheme can be cracked if you throw ... using "in the box" SQL Server technologies. ... Has the behavior of native SQL Server encryption changed such this ... So it's difficult what security hole you ...
      (microsoft.public.sqlserver.security)
    • Re: Encryption
      ... migrate to Sql 2005/8 eventually. ... SA can bypass the encryption. ... The 3rd party shim we use now has caused many ongoing compatibility ... Has the behavior of native SQL Server encryption changed such this ...
      (microsoft.public.sqlserver.security)