Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 0 down vote accepted

It is not used. Details about the encryption algorithm used to encrypt database objects you can find here:

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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