Professional Web Applications Themes

SQL Server 2000 Enryption and Decryption Capability - Microsoft SQL / MS SQL Server

Does SQL Server support Encryption and Decryption of column?...

  1. #1

    Default SQL Server 2000 Enryption and Decryption Capability

    Does SQL Server support Encryption and Decryption of
    column?
    konay Guest

  2. #2

    Default Re: SQL Server 2000 Enryption and Decryption Capability

    No,
    But there are 2 undoented password encryption function
    pwdencrypt/pwdcompare by which you can encrypt and
    decrypt a string.

    Following is the example.

    declare x varbinary(500)
    declare ret int
    select x=convert(varbinary(500),pwdencrypt('check'))
    select pwdcompare('check',x, 0)

    You can use pwdencrypt in a update/insert trigger to
    encrypt the values of a table's column. While decrypting
    you'll have to use pwdcompare which will return 0 or 1 on
    the basis of failed or successfull comparison
    respectively.

    for more information visit
    http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9809

    since these functions are undoented i wont suggest you
    using them. you may go for third party encryption, visit
    following url

    http://www.activecrypt.com/faq.htm

    - Vishal 
    Vishal Guest

  3. #3

    Default Re: SQL Server 2000 Enryption and Decryption Capability

    There is no such built-in functionality. You have to implement it yourself
    or use thirdparty www.netlib.com

    --
    -oj
    Rac v2.2 & QALite!
    http://www.rac4sql.net


    "konay" <com> wrote in message
    news:06b801c36b8d$c6aec890$gbl... 


    oj Guest

  4. #4

    Default Re: SQL Server 2000 Enryption and Decryption Capability

    Just to add another caveat to Vishal's not suggesting you use these
    undoented functions, anyone considering them should also
    take a look here:

    http://packetstormsecurity.nl/papers/authentication/cracking-sql-passwords.pdf

    -- Steve Kass
    -- Drew University
    -- Ref: 8C7E85AB-40F2-4914-BD66-E99487AD8DDF

    Vishal Parkar wrote:
     [/ref]

    Steve Guest

Similar Threads

  1. Replies: 2
    Last Post: July 6th, 03:33 PM
  2. Access 2000 or SQL Server 2000
    By Denis in forum ASP Database
    Replies: 1
    Last Post: January 25th, 03:38 PM
  3. Replies: 5
    Last Post: December 6th, 12:55 PM
  4. Replies: 1
    Last Post: September 5th, 08:55 PM
  5. Replies: 0
    Last Post: September 5th, 01:50 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139