sql server 2000 security

[ammus]

i have a database related to financial...i want that that database more secure...is there any solution ......whether it is possible to automatically encrypt the data and stored it in the database and decrypt the data automatically while i am reriving it...i m using sql server 2000....please helpppp!!!!!!!!!!!

is there any method if i am using using sql server 2005........

[hspc]

In SQL Server 2000, there is no built in encryption and decryption functionality. This is available in SQL server 2005, transparent data encryption is available in SQL Server 2008.
So I think the best option in case of SQL 2000 is to make encryption and decryption in the application logic.
You can find some information about SQL 2005 security in this article:
http://www.databasejournal.com/features/mssql/article.php/3483931

[TheCPUWizard]

You should be able to store the .MDF file on an EFS volume, but you WILL have performance issues...