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
Best Regards
Virusim