Password protecting database and keeping on a removable media.

If I only use 'Password Protection' for my SQL Server Database, is it
sufficient to protect the database? Is the password protection of SQL Server
2000 strong enough?
Why SQL Server 2000 does not possess 'Encrypting Database' feature, when
they have given this facility in MS Access?
I am thinking to keep the database on a removable media like Iomega Zip
Drive so that my client can carry the disk with him, but how it'll effect th
e
database performance?The database password feature in Access is utterly worthless (as is
Access security in general). Google it sometime -- there are thousands
of hits of services offering to bypass it for you. Ditto Access
encryption. It was designed to prevent an mdb from being opened in a
text editor and strings read out of it. Anyone with a copy of Access
can open an encrypted mdb.
For information on SQL Server security, see the following links:
SQL Server Security
http://www.microsoft.com/sql/techin...t.com/security/
Mary
On Mon, 21 Feb 2005 07:25:02 -0800, RPK
<RPK@.discussions.microsoft.com> wrote:

>If I only use 'Password Protection' for my SQL Server Database, is it
>sufficient to protect the database? Is the password protection of SQL Serve
r
>2000 strong enough?
>Why SQL Server 2000 does not possess 'Encrypting Database' feature, when
>they have given this facility in MS Access?
>I am thinking to keep the database on a removable media like Iomega Zip
>Drive so that my client can carry the disk with him, but how it'll effect t
he
>database performance?