Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
add comment

1 Answer

up vote 0 down vote accepted

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/

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
add comment

Your Answer

 
discard

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.