Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
umarsql
Starting Member
3 Posts |
 Posted - 2011-01-13 : 00:53:51
|
| I am using SQL SERVER 2000.As u know we can copy MDF and LDF files and paste them on other PC and easily attach it by EM and view its contents!!!and as u know, MSAccess has an option to set a password to its MDB file!then whenever someone wants to open it, first must enter the password!i want to do on my database like this so that no one except me can easily attach my mdf files and use it!!!is there any way for this...?! |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-01-13 : 04:35:54
|
It is only possible to restrict access to files where they are stored.You can't set a password to the file.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-01-13 : 04:59:39
|
| On SQL 2008 there's TDE, which while it's not a password is a feature for restricting attach, but that's 2008 Enterprise edition only.--Gail ShawSQL Server MVP |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
|
|
|
how to set a password for MDF files?