Hi.
I have created a DB on Sql Server 2008 R2 Express. Currently this DB is attached to
my instance of SQL Server Express which is password protected (not the SQL Express instance). I have created the instance password on the sa account. This was the easiest arrangement so that my C# application can
access the DB. The C# aplication is a windows based application which is deployed to different users machines and accessed the DB using the sa acct and password.
But with this arrangement, one could potentially take the mdf,ldf files and attach the DB to their own instance of Sql Server and then be able to access my relational database design. Is there a good way to protect my DB so that when the files
are moved, the tables, views etc cant be viewed?
Thanks.
Go to the complete details ...