Question how to secure an .mdf file

[knappster]

Hi,
I have a program that I've written in VS2008 and I use a SQL database. I was just wondering, is there anyway that I can secure the .mdf file so that when I deploy the application people can't just attach the file in Management Studio and gain access to the database?

Cheers,
Lee.

 

[MattP]

These 2 articles may be of interest to you

Understanding Transparent Data Encryption (TDE)

Laurentiu Cristofor's blog @microsoft.com : Security and copy protection