<div>
TDE is whole database encryption. &nbsp;So row level is not an option with TDE.
</div>


TDE is whole database encryption.  So row level is not an option with TDE.

<div>
So how will I be able to acheive this?Do I need to write native encryption?
</div>


So how will I be able to acheive this?Do I need to write native encryption?

<div>
You will have to use cell level encryption for the columns. &nbsp;You could use encryption on the application side, but when you want row encryption that has to be different for different tenants, the options are a lot more difficult.
</div>


You will have to use cell level encryption for the columns.  You could use encryption on the application side, but when you want row encryption that has to be different for different tenants, the options are a lot more difficult.

<div>
<div class="content wysiwyg-content">
We have been asked to implement row level encryption for a multi tenant system.<br />
In other words,each client will have unique encryption algorithm.<br />
Can I use TDE &nbsp;feature on SQL 2008 to acheive this?If yes, then how.<br />
Thanks
</div>
</div>


We have been asked to implement row level encryption for a multi tenant system.
In other words,each client will have unique encryption algorithm.
Can I use TDE  feature on SQL 2008 to acheive this?If yes, then how.
Thanks

Row level Encryption for multi Tenant system

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.