How to encrypt database schema(.mdf) of file

Hi,
I have developed an application in which SQL Server 2005 is used as backend.
Once i deploy the application on client machine, others will be able to
access the database schema. How to protect my database file (database schema
)
from others viewing it ?
Thanks in advance,
Gautham.You can't stop them from seeing it if they have sa rights. The only way to
protect yourself legally is with proper copywrites and such.
Andrew J. Kelly SQL MVP
"Gautham" <bv_gautham@.yahoo.com> wrote in message
news:43132353-FC67-4DCB-A9F5-B84E377CF1CE@.microsoft.com...
> Hi,
> I have developed an application in which SQL Server 2005 is used as
> backend.
> Once i deploy the application on client machine, others will be able to
> access the database schema. How to protect my database file (database
> schema)
> from others viewing it ?
> Thanks in advance,
> Gautham.|||Hi,
please read following article by Mr. Vyas its a very good article for sql
server security best practice
http://vyaskn.tripod.com/sql_server...t_practices.htm
HTH
Regards
--
Andy Davis
Activecrypt Team
---SQL Server Encryption Software
http://www.activecrypt.com
"Gautham" wrote:

> Hi,
> I have developed an application in which SQL Server 2005 is used as backen
d.
> Once i deploy the application on client machine, others will be able to
> access the database schema. How to protect my database file (database sche
ma)
> from others viewing it ?
> Thanks in advance,
> Gautham.