DBA > Job Interview Questions > Microsoft SQL Server FAQs

What method would you call to create this key?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What method would you call to create this key?

You want to automate the installation of SQL Server 2005 using SMO for your custom application and ensure that the encryption features are available with a service master key. What method would you call to create this key?

Answer
The Regenerate method under the ServiceMasterKey object.
Explanation
To create a Service Master Key in SMO, you would get a handle to the ServiceMasterKey object under the Server object and then call the Regenerate method.

(Continued on next question...)

Other Job Interview Questions