SQL Server 2005 encryption

[wild_bill]

I've got a table with some encypted data, and I'm not sure how to decrypt it. The encrypted data is a TSQL statement. Given these columns and data, can anybody tell me which encyption method is being used, and/or how to decrypt it?

QueryText image
0x6DD050C1D7CA7AD44B0A11A79547C688D4A84A8C667FBF3DC22FE6DB11ABEF59F3A6E2371B5596C2E2120DF385205F26D7 E16976710DDE01E541448768770AA7

QueryCRC binary(16)
0xBD35F1E607D1EF176865A2C5C34EE0DE

QueryCheckSum int
518

QueryVector int
56

[techgnome]

If that were possible, wouldn't be much of an encryption method then would it?

Problem is that we have no way of knowing if it was encrypted using something in SQL Server, or if it was encrypted outside of the database and only the encrypted data was passed in. Could be a 100 different ways it could have been done.

-tg

[wild_bill]

If that were possible, wouldn't be much of an encryption method then would it?

Agreed, but I have seen these guys use base64 to "encrypt" data.

Problem is that we have no way of knowing if it was encrypted using something in SQL Server, or if it was encrypted outside of the database and only the encrypted data was passed in. Could be a 100 different ways it could have been done.

That's where I'm stuck at. I was hoping given the data, someone might recognize the encryption method. If not, no big deal, it was a long shot, but I thought I would try here.