Re: Encrypt data before inserting into DB

If you encrypt payroll data it wouldn't be possible to write queries like: select everybody with salary > xxx. So it's probably better to use security mechanisms provided by SQL Server. For example, remove SELECT rights to that column from everybody (to provide better performance I'd rather remove rights on whole table) and have people use views or stored procedures instead. Boris