Encrypt the SQL Server 2000 database
Hi
I have a SQL Server 2000 database which has 18 stored procedure and some tables . I like to encrypt the full database so that when we delivar the project to the client they will not able to see out table or stored procerdure source codes but the database will work . Is there a way to encrypt the full SQL server 2000 database
Thanks
# 2 Re: Encrypt the SQL Server 2000 database
Add the WITH ENCRYPTION to your stored procedure statements.
e.g.
create proc myproc with encryption
as
select a,b,c from mytable
This will only encrypt the stored procedures - It's not possible to encrypt tables AFAIK. You can encrypt data stored in tables, but this is typically done from the client side - I would only recommend it for passwords and other sensitive information.
# 3 Re: Encrypt the SQL Server 2000 database
Hi
Thanks for the reply . I like to know how do I encrypt all the stored procedure in a SQL Server database at same time instead of writing the ON Encryption in every single stored procedure .
Thanks
