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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 enforce password in DB attach

Author  Topic 

imrul
Starting Member

36 Posts

Posted - 2010-10-25 : 05:28:42
Hi, I want to enforce a password in attaching a database in a server.
That is, when a user want to attach my database to a new server, it will require a password.

Can any one help?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-10-25 : 06:08:07
Can't be done.

If you have SQL 2008 and TDE you can require a certificate or the DB won't attach. Other than that, no possibilities.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

imrul
Starting Member

36 Posts

Posted - 2010-10-26 : 05:06:17
Thanks for the update
Go to Top of Page
   

- Advertisement -