Friday, March 30, 2012

If i want to encrypt my sql server database, any comments? any too

Hi,
If i want to encrypt my sql server database, do you have any comment?
Any issue for that? Any tools that is suggested to use?
Thanks a lot!
regards,
florencelee
Hi
If you want to encrypt data, do it in your application and then store it in
SQL Server. SQL Server 2000 and below does not support encryption at data
level.
If you want to encrypt views and stored procedures, you can create the views
and SPs with the ENCRYPTION option. But, this encryption is weak and can be
cracked.
If you have business logic that is so secret, put it into your application,
where it belongs.
Regards
Mike
"Florencelee" wrote:

> Hi,
> If i want to encrypt my sql server database, do you have any comment?
> Any issue for that? Any tools that is suggested to use?
> --
> Thanks a lot!
> regards,
> florencelee

No comments:

Post a Comment