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.