question

suraj avatar image
suraj asked

decrypt views & store procedure

how to decrypt the views & store procedure in sql server

t-sqlencryption
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TimothyAWiseman avatar image TimothyAWiseman commented ·
I am clearly not a lawyer, but I feel obliged to point out that if you are using that to get to someone elses code you could be violating the DMCA anti-circumvention requirements in addition to any normal copyright issues.
1 Like 1 ·
CirqueDeSQLeil avatar image
CirqueDeSQLeil answered

That will greatly depend on your version of SQL server. There are plenty of examples out there on the net for each version.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image
Matt Whitfield answered

There are two ways of doing it, the 'ALTER PROCEDURE to derive the key' kind of way, and the 'generate the key from the relevant parts of the database' kind of way. I would advise trying to use the latter, as that means you don't actually make any changes to the database in order to perform the decryption.

Another thing, on SQL 2005+ you have to be connected to the DAC in order to be able to get to the encrypted text of the SQL module.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Squirrel avatar image
Squirrel answered

my point of view is, if you are a legal owner of the views or stored procedure, you should have access to the original un-encrypted source. If you are not the legal owner, this is an act of stealing and infringed of intellectual property rights.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Peso avatar image
Peso answered

No, my account has not been hacked. Thank you all for noticing this post.

My answer was supposed to go to another question where that OP wanted to know if there was a way to totally clear a database of all tables, regardless of FK-constraints.

//Peter

1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
+1, should counteract all the minuses :)
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.