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
    Commented Jan 9, 2013 at 13:33
  • Thanks. I thought this was true, but wanted to be sure.
    – shawno
    Commented Jan 9, 2013 at 21:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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