Hi,

I have some simple question on SQL server 2000.

01) Why is it that when I detach a DB, change the SA password, then attach back the DB, I can still view the attached DB content. Should it be asking me for the old password before it can view the content ? Any way to implement such that the content cannot be view at all ?

02) If I want to protect my DB from user looking at my table structure and SP (stored procedure and views), any way or method to implement it ? I know that encryption of SP will not help much as there are third party tool to decrypt it back.

03) I just want to prevent unauthorized user from copying back my DB. Is encryption of the whole DB the only way, any other better way or method. Pleae advise.

Thank you