Results 1 to 7 of 7

Thread: Encrypt all

  1. #1
    Join Date
    Feb 2003
    Location
    Milano, Italy
    Posts
    80

    Unanswered: Encrypt all

    Hi to all

    i have A LOT of stored procedures that i have to encrypt. There is any nice way to do it automatically without having to ALTER them with the ENCRYPTION keyword one by one?

    Thanx in advance
    Davide Mauri
    http://www.davidemauri.it

  2. #2
    Join Date
    May 2003
    Location
    Epsom, United Kingdom
    Posts
    42

    Re: Encrypt all

    I don't believe there is another way to do it. BOL makes it very clear the syntax required for altering a SP.

    Good luck and I hope you have plenty of time on your hand.
    Shadow to Light

  3. #3
    Join Date
    Feb 2003
    Location
    Milano, Italy
    Posts
    80
    can i say "oh sh*t" ? :-)

    i expected that anyway....just need to be sure of it

    thanx
    Davide Mauri
    http://www.davidemauri.it

  4. #4
    Join Date
    May 2003
    Location
    Epsom, United Kingdom
    Posts
    42
    I think you will be saying on S**t for every one you have to do manually!

    Just remember to backup them up safely becaus once encrypted... you know the rest!

    Good luck and have fun. Perhaps you could use this weekend to do it?!
    Shadow to Light

  5. #5
    Join Date
    Feb 2003
    Location
    Montreal, Canada
    Posts
    117
    Every encrypted procedure can be decrypted, so if you just want to protect the code by doing that, don't waste your time. The code can be easily extracted even if is "encrypted".

    Originally posted by Crespo-n00b
    I think you will be saying on S**t for every one you have to do manually!

    Just remember to backup them up safely becaus once encrypted... you know the rest!

    Good luck and have fun. Perhaps you could use this weekend to do it?!
    Steve

  6. #6
    Join Date
    Feb 2003
    Location
    Milano, Italy
    Posts
    80
    mmm...not so sure of it. the only method to decrypt a sql server encryption should the the brute-force method, since encryption is irreversible.

    am i wrong? if yes can you show the proof?
    Davide Mauri
    http://www.davidemauri.it

  7. #7
    Join Date
    Feb 2003
    Location
    Montreal, Canada
    Posts
    117
    Well, take a look at
    http://www.planet-source-code.com/vb...d=505&lngWId=5

    Originally posted by manowar
    mmm...not so sure of it. the only method to decrypt a sql server encryption should the the brute-force method, since encryption is irreversible.

    am i wrong? if yes can you show the proof?
    Steve

Posting Permissions

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