sql server msde: Hello

Is it posible to encrypt whole database in Sql 2005 Express. I need it for
deployment process of my application and hiding database structure?

Or if not is good solution to use third party software for this propose?

Thank you

The easiest way to encrypt a whole database is to put it in an encrypted
NTFS directory. That has some performance implications obviously and may or
may not do what you want it to depending on who you want to hide the data
from.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

hi,
[quoted text, click to view]

regarding "hiding database structure", you can perhaps deny VIEW DEFINITION
permissions
http://msdn2.microsoft.com/en-us/library/ms175808.aspx and
http://msdn2.microsoft.com/en-us/library/ms187113(en-us,VS.90).aspx , even
at the database "securable" level..
the other traditional permission (SELECT/INSERT/UPDATE/DELETE/EXEC) should
be managed as well as in any security concerned scenario... drop the "Guest"
database user and define an appropriate object access policy..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply