Are you asking for a way of encrypting the database files after they have been detached or while the db is in use. If you want the ensure "encryption for data at rest" you can look at SQL Server 2008 Transparent Data Encryption (TDE).
TDE is a little more complex than just a basic password, it includes certificates, keys, passwords, etc. It is unfotunately limited to SQL Server 2008 +
Here is the link:
Understanding Transparent Data Encryption (TDE) [
^]
I hope this helps.