Storing Data Encrypted in SQL 2K possible?
Posted on 2006-11-24
Hello all. Here is what I am trying to accomplish. I can access an external SQL Server which is open just to my specific IP address. What I want to do is somehow setup a SQL Job to transfer a two field table and store the data encrypted on the external box. Then in a application I have decrypt the data possibly. Is there a way in SQL Server to lock down the table and store the data encrypted? I know I can do this in a application but the problem is we are talking millions of rows I need to transfer on a weekly basis.