 Ghinx
|
| Joined: 04 Oct 2006 |
| Total Posts: 1 |
| |
|
SQL Sever Encryption
Posted: 05 Oct 2006 01:57 PM |
Dear all
Anyone out there know if there is any type of encryption methology which can be used in SQL Sever 2000. I am talking about SQL Server.
Any help or advice is appreciated.
Regards
Ghinx
|
|
|
 |
|
ace
|
 |
| Joined: 24 Jun 2004 |
| Total Posts: 200 |
| |
|
Re: SQL Sever Encryption
Posted: 21 Oct 2006 03:39 PM |
Hi!
You have a number of options I suppose. Depends on what you are trying to do. Both encrypt and decrypt or just encrypt, for example.
I know of third party products that install DLLs, etc that can be used. An example would be http://www.xpcrypt.com/. Can't vouch for them. I would be "nervous" about using third party vendors...
Alternatively I have see a encrypt and decrypt function implmented as a UDF or SP. I have seen a number of examples over the years, I am sure a search via Google will give you some examples.
Another approach, if you want to go one way, is to use SQL Server's encytpion function. Check out the text of the sp_addlogin system stored procedure for an example.
Of course a better technique would be to call Window's cryptography APIs. Much better. Never played around with it, so only know that it is possible.
So, some ideas hopefully...
HTIR,
Victor |
|
|
|
|
|
Re: SQL Sever Encryption
Posted: 27 Feb 2008 04:06 PM |
I don't suppose you have the option to upgrade to SQL Server 2005?
There is backed in row level encryption and other goodness which also has some performance implications (all encryption does), but it can radically change your policy/design approach. |
|
|
|
|