I need to encrypt and decrypt certain columns in certain tables inside a
stored proc. Can this be done and if so how? Thanks for any advice. This is
SQL Server 2005.

Let me expand the question.

I followed the example in BOL for asynchronous encyption. I modified it
enough to contain a sizable varbinary (2K containing about 1300 bytes (a
binary serialization of a c# object.)

As far as I know it encrypts, but the decryption always returns null.

Any guesses as to why it fails? Too large? Can't handle binary?

thx
md

*** Sent via Developersdex http://www.developersdex.com ***

Let me expand the question.

I followed the example in BOL for asynchronous encyption. I modified it
enough to contain a sizable varbinary (2K containing about 1300 bytes (a
binary serialization of a c# object.)

As far as I know it encrypts, but the decryption always returns null.

Any guesses as to why it fails? Too large? Can't handle binary?

thx
md

*** Sent via Developersdex http://www.developersdex.com ***

Let me expand the question.

I followed the example in BOL for asynchronous encyption. I modified it
enough to contain a sizable varbinary (2K containing about 1300 bytes (a
binary serialization of a c# object.)

As far as I know it encrypts, but the decryption always returns null.

Any guesses as to why it fails? Too large? Can't handle binary?

thx
md

*** Sent via Developersdex http://www.developersdex.com ***

Let me expand the question.

I followed the example in BOL for asynchronous encyption. I modified it
enough to contain a sizable varbinary (2K containing about 1300 bytes (a
binary serialization of a c# object.)

As far as I know it encrypts, but the decryption always returns null.

Any guesses as to why it fails? Too large? Can't handle binary?

thx
md

*** Sent via Developersdex http://www.developersdex.com ***

Let me expand the question.

I followed the example in BOL for asynchronous encyption. I modified it
enough to contain a sizable varbinary (2K containing about 1300 bytes (a
binary serialization of a c# object.)

As far as I know it encrypts, but the decryption always returns null.

Any guesses as to why it fails? Too large? Can't handle binary?

thx
md

*** Sent via Developersdex http://www.developersdex.com ***

Let me expand the question.

I followed the example in BOL for asynchronous encyption. I modified it
enough to contain a sizable varbinary (2K containing about 1300 bytes (a
binary serialization of a c# object.)

As far as I know it encrypts, but the decryption always returns null.

Any guesses as to why it fails? Too large? Can't handle binary?

thx
md

*** Sent via Developersdex http://www.developersdex.com ***

Let me expand the question.

I followed the example in BOL for asynchronous encyption. I modified it
enough to contain a sizable varbinary (2K containing about 1300 bytes (a
binary serialization of a c# object.)

As far as I know it encrypts, but the decryption always returns null.

Any guesses as to why it fails? Too large? Can't handle binary?

thx
md

*** Sent via Developersdex http://www.developersdex.com ***

Let me expand the question.

I followed the example in BOL for asynchronous encyption. I modified it
enough to contain a sizable varbinary (2K containing about 1300 bytes (a
binary serialization of a c# object.)

As far as I know it encrypts, but the decryption always returns null.

Any guesses as to why it fails? Too large? Can't handle binary?

thx
md

*** Sent via Developersdex http://www.developersdex.com ***