Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Location
    san jose
    Posts
    6

    Unanswered: Encryption at the database field level

    Hello Everyone

    I need a solution for the following problem ASAP

    Configuration
    SQL 2000 ENT Edition
    Client - Server Application Designed in VB

    I have one filed in one of my tables in a database E.g Credit Card Number. I need this fields to be Encrypted so that no body can see and mis use that information. One option is to change the application and incorporate the encryption logic into the application. Does SQL 2000 Provides some kind of Encryption at a field level? or can i manage this thing at the database level? I desperatelly want to do it at the database level.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to this MSDN link about using SSL communication.

    Also on SQL Server level you can use MULTI-PROTOCOL netlib with ENCRYPTION option for the security, refer to books online for more information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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