Since the inception of SQL Server 2005 data encryption and cryptography functionality has elevated to a new level, this wasn't the case until SQL 2000 version. The overall security improvements within SQL 2005 is mainly with 'certficate' authentication, the 3 levels are: Authentication – subjects (persons, devices, services) are granted access to the server (e.g. through HTTP endpoints, as database principals) after a valid certification path has been verified; Module signatures – procedures, functions,...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/perftune/archive/2007/09/13/2086.aspx