<div>
Depends on how you want to encrypt.<br />
If you are interested in at-rest encryption, then you can simply encrypt the storage media (bitlocker, efs, whatever) <br />
<br />
If you want to do explicit encryption, then you need to alter apps to use the 2008 crypto primitives (such as <a href="http://msdn.microsoft.com/en-us/library/ms174361.aspx" rel="ugc">ENCRYPTBYKEY</a> - that means coding changes.<br />
<br />
if you want to do this without altering the code, then you need to follow <a href="http://msdn.microsoft.com/en-us/library/bb934049%28v=sql.100%29.aspx" rel="ugc">this guide</a> to Transparent Data Encryption - might take a couple of looks before you get the idea, so feel free to post follow up questions in this thread for clarification :)
</div>


Depends on how you want to encrypt.
If you are interested in at-rest encryption, then you can simply encrypt the storage media (bitlocker, efs, whatever)

If you want to do explicit encryption, then you need to alter apps to use the 2008 crypto primitives (such as ENCRYPTBYKEY [http://msdn.microsoft.com/en-us/library/ms174361.aspx] - that means coding changes.

if you want to do this without altering the code, then you need to follow this guide [http://msdn.microsoft.com/en-us/library/bb934049%28v=sql.100%29.aspx] to Transparent Data Encryption - might take a couple of looks before you get the idea, so feel free to post follow up questions in this thread for clarification :)

<div>
Hi thank you for the info.<br />
<br />
I was interested for encryption at rest and in transit, when data is moving. <br />
Without altering the code would be great. Is the transparent data encryption used when data is in transit?
</div>


Hi thank you for the info.

I was interested for encryption at rest and in transit, when data is moving.
Without altering the code would be great. Is the transparent data encryption used when data is in transit?

<div>
<div class="content wysiwyg-content">
Hello experts,<br />
<br />
DO you have any tutorial, suggestions &nbsp;on how to encrypt tables on database MSSQL 2008? <br />
Once they are encrypted, would it affect my ASP.net applications I have when i call such tables?<br />
<br />
<br />
thank you
</div>
</div>


Hello experts,

DO you have any tutorial, suggestions  on how to encrypt tables on database MSSQL 2008? 
Once they are encrypted, would it affect my ASP.net applications I have when i call such tables?


thank you

Encryption on database tables MSSQL 2008

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Encryption is the process of encoding messages or information in such a way that only authorized parties can read it. In an encryption scheme, the intended communication information or message, referred to as plaintext, is encrypted using an encryption algorithm, generating ciphertext that can only be read if decrypted. For technical reasons, an encryption scheme usually uses a pseudo-random encryption key generated by an algorithm. An authorized recipient can easily decrypt the message with the key provided by the originator to recipients, but not to unauthorized interceptors.