Encrypting Data using TSQL

I need to find a way of encrypting and decrypting data from SQL server 2000. I need to do this as transparently as possible, which is why I need to do this if at all possible before my web application encounters the data.

I know this is possible without 3rd party applications using SQL server 2005, as I have a working implementation already; however I need to do this with SQL server 2000 as upgrading is not an option. Using a 3rd party product to encrypt/decrypt is also not possible.

Any help much appreciated.

Matt Rose

You can write a stored procedure on your own,either as a extended stored procedure or you make a call to a COM object. Both options are not very niuce, compared to buying a thrid party products which was extensivly tested. Furtherone you could do this in your business logic, but as you don′t want to interfer with the curretn architecture, I guess this is not an option for you.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

What is the difference between a 3rd party product and writing something homegrown? (it's not necessarily cheaper to 'do it yourself' everytime)

Here's something that seems to do what you need - http://www.xpcrypt.com/ - though I haven't used it so I can't say if it's good or not.

/Kenneth

|||

Thanks for the suggestions. Unfortunately, I do have to do this myself because I've been told that there is no money available for a third party product.

No worries, I've found a solution to the problem from within the web application I was writing; the encryption and decryption is done by the application using a class library.

Thanks

Matt Rose