Results 1 to 3 of 3

Thread: Encryption in MS SQL Server 2000

  1. 03-15-2005, 11:45 AM #1
    TheLoneStar
    TheLoneStar is offline Registered User
    Join Date
    Mar 2005
    Location
    Germany
    Posts
    10

    Encryption in MS SQL Server 2000

    Hi!

    I need an encryption functionality in my MS SQL Server 2000 database for stored procs. I consider to use the undocumentated feature of MS SQL Server "pwdencrypt" and "pwdcompare".
    Are they recommended? Are there other possibilities to implement encryption in MS SQL Server (, that are free!!)?

    regards,

    TheLoneStar
    Reply With Quote Reply With Quote
  2. 03-16-2005, 11:15 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Are you trying to encrypt stored procedure itself or the data?. You can create encrypted stored procedure by adding WITH ENCRYPTION option in CREATE PROCEDURE statement.

    For data, check this

    http://www.activecrypt.com/products.html
    http://www.appsecinc.com/products/db...lgorithms.html

    SQL Server 2005 has builtin procedures to do it

    http://www.databasejournal.com/featu...le.php/3483931
    Reply With Quote Reply With Quote
  3. 03-16-2005, 03:58 PM #3
    Rawhide's Avatar
    Rawhide
    Rawhide is offline Registered User
    Join Date
    Feb 2003
    Posts
    1,048
    Just be aware that if you use the WITH ENCRYPTION option, you can't decrypt the procedure. Keep a regular text backup.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules