Im trying to explore some encryption options on Microsoft SQL Server 2005.

Ive recently got around SQL Server 2008 and was able to enable Transparent Data Ecnryption(TDE). Now I'm trying to figure out encryption options for SQL Server 2005.

Can someone tell me how to achieve TDE for 2005 MsSql Servers? If thats not possible can someone point in other directions for me. I also understand that cell level encryption must be done on the application side.

PS: The server edition is standard edition. I've been trying to find answers for 2005 for few hours now and most of my answers are for 2008 SQL Server.

I'm trying to explore some encryption options on Microsoft SQL Server 2005.

I've recently got around SQL Server 2008 and was able to enable Transparent Data Encryption (TDE). Now I'm trying to figure out encryption options for SQL Server 2005.

Can someone tell me how to achieve TDE for SQL Server 2005? If that's not possible, can someone point me in the right direction? I also understand that cell level encryption must be done on the application side.

PS: The server edition is Standard Edition. I've been trying to find answers for 2005 for a few hours now but most are for SQL Server 2008.