Lynn Pettis (12/21/2009)
If it can be done transparently at the database level there may be a better chance of developers making use of the technology when it is needed without specialized coding.
We are talking the same thing SQL Server 2005 and up comes with DPAPI check the links below there is T-SQL code in the first link.
http://msdn.microsoft.com/en-us/library/ms179331(SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms189586(SQL.90).aspx
Kind regards,
Gift Peddie