Hi Friends ,

            I want to create a table in which , i want to declare some fields as encrypted at the time of creation so that tha data entered in that fields could not be seen by anybody .

           Can you please guide me.


Thanking you ,
Param.

There's no built-in function that you can use that will automatically encrypt the data that you insert into your table. One way of doing it is to create your own encryption/decryption algorithm that you can call as a function and use whenever you insert data in your table.

Alternatively, here's a link to an encryption/decryption function that performs a simple algorithm in encrypting a string value:

http://www.sql-server-helper.com/fun...ncryption.aspx

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp

Thank you friend SSHelper


                Your Suggestions and the link you have given me is really helpful to me.



Thanking you
Param

If you think your data is worth encrypting or you need to pass a security inspection, you won't use a homegrown method... security inspectors come armed with code to easily ferret out and break these homegrown solutions and you will flunk the inspection.

I believe that the SDK (Software Developers Kit) that comes with SQL Server has some good strong DESI multi-key encryption methods.

If it's worth protecting, do it right.

--Jeff Moden

Ther's also some SQL in this thread http://p2p.wrox.com/topic.asp?TOPIC_ID=51187 that uses the freely available CAPICOM library.

--

Joe (Microsoft MVP - XML)