The DB admin may have created these keys. Data encryption is the key to data security. With SQL Server 2005 you can secure your data by using the encryption or decryption functions that it provides.

Encrypt a column using Stored procedures So first of all I created a Symmetric key called MY_KEY in my database. If you look under security you will find the place to create the this key.

DbEncrypt for SQL Server 2.1, which will be unveiled this week, takes far fewer round trips between its encryption engine and a SQL Server database, resulting in a fivefold-to-tenfold performance ...