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.

How to Duplicate a SQL Instance

Is there a way to duplicate a SQL instance existing on one machine to
another machine ? This is for debugging purpose of some applications
running against the databases on such instance without disturbing the
production machine. I need the exact SQL instance environment with all the
databases contained. If there is no such tool available, then what do you
recommend to accomplish this ?
TIA
MacThis article will give you some pointers:
http://vyaskn.tripod.com/moving_sql_server.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
news:bql5al$kqa$1@.si05.rsvl.unisys.com...
Is there a way to duplicate a SQL instance existing on one machine to
another machine ? This is for debugging purpose of some applications
running against the databases on such instance without disturbing the
production machine. I need the exact SQL instance environment with all the
databases contained. If there is no such tool available, then what do you
recommend to accomplish this ?
TIA
Mac|||Thanks Vyas. Lots of good info in there..
// Mac
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:ehEWyDcuDHA.536@.tk2msftngp13.phx.gbl...
> This article will give you some pointers:
> http://vyaskn.tripod.com/moving_sql_server.htm
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> What hardware is your SQL Server running on?
> http://vyaskn.tripod.com/poll.htm
>
> "Mac Vazehgoo" <mahmood.vazehgoo@.unisys.com> wrote in message
> news:bql5al$kqa$1@.si05.rsvl.unisys.com...
> Is there a way to duplicate a SQL instance existing on one machine to
> another machine ? This is for debugging purpose of some applications
> running against the databases on such instance without disturbing the
> production machine. I need the exact SQL instance environment with all
the
> databases contained. If there is no such tool available, then what do
you
> recommend to accomplish this ?
> TIA
> Mac
>
>