>>We are using SQL Server Standard 2008. Several of the columns are encrypted using a symmetric key. The key is opened when the application is launched and kept open until the application is exited and works as expected. While using the app the key is somehow being closed. Requeries are returning nulls instead of decrypting the data. Any ideas as to how this is happening?
>
>The key will be closed when connection is closed. Make sure that you're not closing and re-opening connection in your application or open the key when you are re-opening connection. You can check for open keys using sys.openkeys system view.

We are using an object to establish a connection and open the key, i.e. the key is always opened when the connection is made. We are not closing the connection until the app is exited. A requery returns encrypted data after we use spt to update data that needs to be encrypted.