How to encrypt store in sql2005?

I have a Store in sql 2005!
I want to encrypt this ? how ?

Thanks !

Hi, a good starting point for learning SQL Server 2005 encryption is located here:

http://blogs.msdn.com/lcris/archive/2005/06/09/427523.aspx

and

http://blogs.msdn.com/lcris/archive/2005/06/10/428178.aspx

Both Laurentiu and Raul have many good posts regarding SQL Server Security in their blogs which you can reference here:

http://blogs.msdn.com/lcris

http://blogs.msdn.com/raulga

Please let us know if you have any further questions.

Thanks,

Sung

|||Thanks Sung !

I had a Store procedure with Encryption;

Create Produce TestEnCryption With Encryption

AS

Begin

Select * from Customer

End

|||

Ah, I see, sorry for the misunderstanding. I didn't realize you were trying to encrypt a stored procedure.

The encryption we have for stored procedures is weak and is probably better referred to as obfuscation. In general, it's very difficult to keep a stored procedure secret from the user, especially if the user is a sysadmin for the database.

The blogs I outlined above are for data encryption (and other security related features) and these have very strong encryption.

Please let us know if you have more questions.

Thanks,

Sung

|||

As Sung pointed out, the WITH ENCRYPTION option for procedures is an old option that is kept around for background compatibility. It is not a security feature.

Thanks

Laurentiu