I'm using SQL Server 2005 and want to take benefit of SQL Server 2005 encryption capabililties.
I would like to crypt some sensitive data in a table.
We use to access data only through SPs which are called automatically by external programs.
I was wondering how secure it was to crypt / encrypt from a stored procedure as it seems that all Encryption functions need some kind of password.
I could encrypt the SP itself but you can find so many tools to decrypt SPs that it does not seem a very secure solution.
Does anyone has an idea on the way to secure the data in this case ? Use of CLR function or Extended SPs or anything else that I did not think about ?
I don't want the encryption to be managed by the application but only at SQL Server level...