Welcome! Log In Create A New Profile

Advanced

Encryption in MS SQL

Posted by PETER ZHOU 
Forum List Message List New Topic
PETER ZHOU
Encryption in MS SQL
November 28, 2008 11:22AM
Hi,

Any experience with data/tables encryption in MS SQL ?

Is there a built-in function in MS SQL or i need to use the webdev encryption/decyrpt every data saving into & reading from MS SQL ?

Regards,

PETER ZHOU
Reply Quote
Paulo Oliveira
Re: Encryption in MS SQL
November 28, 2008 01:52PM
In MS SQL 2005 go to MS SQL books online and look for "encryption [SQL Server], columns"

In MS SQL 2000 i don't know anyt way of doing it. MS SQL 2000 help:
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.
Reply Quote
Newer Topic Older Topic
Author:

Your Email:


Subject:
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: