Is there a way to protect a specific database within a Microsoft SQL instance in version 2005 and 2008?
We are trying to do this in 2 ways:
An instance of SQL may have 5 databases and we want one of them not to be accessible by the SQL Studio or any other apps unless some sort of password is entered.
If a DB is detached and attached to another instance; we want the other instance being access by its SQL Studio or its apps have access only if a password is used.
Is there a way to go about this?