Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Encrypt Data Issue

    Does SQL Server 2000 provide any data encryption/decryption functionality so that certain fields (e.g. SSN, Age and Salary) will be encrypted before writing into the table and decrypted once loading out of the table?


  2. #2
    Join Date
    Nov 2002
    Look up encryption in Books Online

    Quote Originally Posted by BOL
    Using Encryption Methods
    Encryption is a method for keeping sensitive information confidential by changing data into an unreadable form. Encryption ensures that data remains secure by keeping the information hidden from everyone, even if the encrypted data is viewed directly. Decryption is the process of changing encrypted data back into its original form so it can be viewed by authorized users.

    Microsoft® SQL Server™ encrypts or can encrypt:

    Login and application role passwords stored in SQL Server.

    Any data sent between the client and the server as network packets.

    Stored procedure definitions.

    User-defined function definitions.

    View definitions.

    Trigger definitions.

    Default definitions.

    Rule definitions.

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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