encryping - decrypting stored procedures

Hi all...

Im wondering how do you encrypt and decrypt a stored procedure within sql server 2000 ?

i want to be able to encrypt data been inserted / updated using triple des algorithm and then on select / read - decrypt it.

Does anyone know a solution / stored procedure on how to do this? any ideas.

Thanks

Paul..

Im also wondering if there is a away of doing this on the code side without using stored procedures (asp.net c#) i have been able to encrypt and decrpt to a string but unable to do it through the datagrid object (dataset) or a datareader..

Any tips / help would be helpful

Thanks..You may implement a sql server function to encrypt and decrypt when insert or select.

Just my 2 cent.

Scott

Software Design Group|||The following article could possibly provide some thoughts;

http://www.15seconds.com/issue/030310.htm