I need to encrypt files in tables (customer names for example). If an employee leaves the company he won't get that information if he steals the files.

>I guess I didn't read that far into it. I was assuming he needed to encrypt certain fields like passwords and credit card numbers.
>
>>That depends on what you need to protect. From what I understand from Denis request, he want to protect his tables from being opened with NotePad. SQL Server on itself will do the job.
>>
>>>How do you implement encryption on SQL Server. We used to use the SQL Server ENCRYPT() function, but got bit hard by that when we tried to migrate to a different server.