Click here to Skip to main content
15,611,422 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
How i Can use Password on my Database File?
[no name] 15-Oct-12 9:34am    
Maybe you can explain what it is that you are trying to do so you can get a decent answer to your question.

Applying a password is pretty simple:[^] but as it says, that may ot do what you want, as it does not prevent anyone from reading the file as a byte stream.

You might want to consider encryption as well / instead.
Share this answer
Are you asking for a way of encrypting the database files after they have been detached or while the db is in use. If you want the ensure "encryption for data at rest" you can look at SQL Server 2008 Transparent Data Encryption (TDE).

TDE is a little more complex than just a basic password, it includes certificates, keys, passwords, etc. It is unfotunately limited to SQL Server 2008 +

Here is the link:
Understanding Transparent Data Encryption (TDE) [^]

I hope this helps.
Share this answer
Ali91Asadi 15-Oct-12 13:05pm    

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900