Is the Service Master Key (SMK) used to encrypt stored procedures in SQL Server 2008?

I know it is used for data, but what about database objects? If the Service Master Key is not used, then I would expect that if one were to do a database recovery from one server to another (without restoring the SMK) that the stored procedures would continue to work.

Is this true?


1 Answer 1


It is not used. Details about the encryption algorithm used to encrypt database objects you can find here: http://sqlity.net/en/1617/decrypting-encrypted-database-objects/

  • It's worth mentioning that the algorithm - and thus the attack method - remains exactly the same in SQL Server 2012.
    – db2
    Jan 9, 2013 at 13:33
  • Thanks. I thought this was true, but wanted to be sure.
    – shawno
    Jan 9, 2013 at 21:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.