Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Encryption

Author  Topic 

Geno
Starting Member

2 Posts

Posted - 2005-07-07 : 12:10:48
Hello,
I am needing to migrate an Access database to Sql Server
Express. This database will be distributed as part of a
VB 6 application. This database will have some of the
columns encrypted. My understanding is that SQL Server
Express supports encryption. We will need to be able to
run queries on encrypted data like this, with
LastName being an encrypted column in the database.

Select LastName from Account where LastName = 'Smith'
Select LastName from Account where LastName Like 'Sm%'
Update Account Set where LastName = sLastName

Can this be done using SQL Server 2005 Express and VB 6?

Thanks!

aakash
Starting Member

8 Posts

Posted - 2005-10-19 : 20:44:53
Refer to

http://msdn2.microsoft.com/en-us/library/ms179331

for information on how to encrypt/decrypt data in the database.

-Aakash
Developer, SQL Server engine
Go to Top of Page
   

- Advertisement -