Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Encryption and Serialization using CLR stored procedure

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-03-07 : 08:41:20
Jahnavi writes "I have some logic for Encryption and Decryption following the Serialization and Deserialization of an object.

I would like to move this approach to CLR stored procedures to leverage the advantages in SQL 2005.

Could you please provide me with the details of the pros and cons of the approach and the various possibilities over this.

Would be glad to receive any kind of inputs from you.

Thanks,
Jahnavi"

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2007-03-07 : 10:57:18
Do you know that there are encryption and decryption functions built in to SQL Server 2005, so you don't have to roll your own in CLR code?
See http://msdn2.microsoft.com/en-us/library/ms179331.aspx
Go to Top of Page
   

- Advertisement -