store procedure and view with ENCRYPTION

• oigo

  SSC-Addicted

  Points: 422

  More actions

  June 6, 2002 at 9:42 am

  #78819

  Hello, I made a store procedure and one view with ENCRYPTION , how can I their text using T-SQL?

  Thanks

• danw

  SSCommitted

  Points: 1842

  More actions

  June 6, 2002 at 11:03 am

  #430445

  I think the only way would be to break the Sql Server encryption...

  I've never tried it but it looks like it can be done:

  http://www.sqlsecurity.com/uploads/sql2k_spcrypto.txt

  Good Luck,

  Dan

• K. Brian Kelley

  SSC Guru

  Points: 114703

  More actions

  June 6, 2002 at 11:22 am

  #430448

  It can be done and there are programs which will decrypt for SQL 7 and 2000 available.

  K. Brian Kelley

  bkelley@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/bkelley/

  K. Brian Kelley
  @kbriankelley

• Antares686

  SSC Guru

  Points: 125444

  More actions

  June 6, 2002 at 3:09 pm

  #430469

  Hey Dan, thanks for the link. I had been looking for it myself and will test when I get a chance.

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)