Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2003
    Posts
    44

    Unanswered: Encrypt a stored procedure.

    How might I encrypt a stored procedure in SQL server.

    In sybase this is done with SP_HIDETEXT but SQL server doesn't appear to have this.

    Is there another way?

    Thanks,

  2. #2
    Join Date
    Jan 2004
    Posts
    49
    use WITH ENCRYPTION option wen you create SP, VIEW or UDF....
    but it's useless...
    fo details see BOL

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Calling it "Useless" is unnecessarily harsh.

    FYI, the Hitchhiker's Guide to the Galaxy recently expanded its definition of SQL Enryption from "Useless" to "Mostly useless".
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Jan 2003
    Location
    London, England
    Posts
    106
    Just a clairification:

    CREATE PROCEDURE dbo.MyProcName WITH ENCRYPTION
    as
    ...
    Frettmaestro
    "Real programmers don't document, if it was hard to write it should be hard to understand!"

  5. #5
    Join Date
    Jan 2004
    Location
    Boston
    Posts
    58
    Well, it's surely an excellent way of protecting vendor's coding.

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Nope. The encryption scheme is pretty simple and was cracked some time ago. Decryption routines are readily available on the net.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •