Triggers+encryptography issue

Last Post 22 Jul 2007 09:32 AM by SQLUSA. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Co0LDB
New Member
New Member

--
05 Jun 2007 11:09 PM
Hi there,
Guys I need help… have developed a web-based application using ASP.NET +VB.NET + C#.NET and used SQL Server 2000. In the SQL 2000 I have used triggers to handle some operations. Then I have upgraded my DB to SQL Server 2005 to speed up my application, soon after I have implemented encryptography “in the .NET” to encrypt the data in the DB. After I have implemented all successfully the problem came up which is the triggers couldn’t handle the operation coz the data they deals with is now encrypted, causing a really big matter to me….

Anyone have idea or suggestions to guide me to solve my matter

Best regards
Co0LDB
New Member
New Member

--
06 Jun 2007 11:27 PM
Thanx for your reply mate,,,,

Guys my problem basically is that the triggers cannot read the encrypted data coz it is not recognized them and the triggers need to do some operation on these encrypted data and then to be saved in the data base. What I need to know if there is a way in sql 2005 that can make the triggers use the same algorithm to encrypt and decrypt the data back to be saved encrypted in the db.

do i have to convert the encryption algorithm to a DLL file ?
is there a way to make the SQL trigger import the DLL file to be used.

thanking u in advance

SQLUSA
New Member
New Member

--
22 Jul 2007 09:32 AM
Why are you using trigger?

Why are you using encrypted data?

Kalman Toth, Database Architect
SQL Sever Training - http://www.sqlusa.com
You are not authorized to post a reply.

Acceptable Use Policy