<div>
<div class="content wysiwyg-content">
I want to store secure data in the database. <br />
<br />
I have no idea on how to go about that. lets say there are three pieces of information that i can store along with user id in one table<br />
so four &nbsp;columns i would think. <br />
<br />
the ID can be not secured I guess and its needed for lookup<br />
<br />
now what is the best way to store the other information and why?<br />
<br />
ms sql 2005, asp.net 2005, win 2008 + 2in 2003<br />
<br />
thanks in advance. 
</div>
</div>


I want to store secure data in the database. 

I have no idea on how to go about that. lets say there are three pieces of information that i can store along with user id in one table
so four  columns i would think. 

the ID can be not secured I guess and its needed for lookup

now what is the best way to store the other information and why?

ms sql 2005, asp.net 2005, win 2008 + 2in 2003

thanks in advance. 

Store Secure Data in Database

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

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.

Encryption

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