The SMO Database Class

Question

The SMO Database Class

Steve Jones - SSC Editor

SSC Guru

Points: 736078
More actions
February 13, 2017 at 10:04 pm

#401612

Comments posted to this topic are about the item The SMO Database Class

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Stewart "Arturius" Campbell SSC Guru Points: 72619 More actions · Answer 1

Interesting question, thanks Steve.
Had to read up on this

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

paul s-306273 SSChampion Points: 10730 More actions · Answer 2

Stewart "Arturius" Campbell - Monday, February 13, 2017 11:39 PM
Interesting question, thanks Steve.
Had to read up on this

+1

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

I had to research it as well. I like the questions where I learn something, so thanks Steve.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Stephanie Giovannini SSCertifiable Points: 7422 More actions · Answer 4

Despite both references (including MSDN) stating that the Database class can be used to create a master key, it doesn't appear to be an outright ability of the Database class. Note that the property Database.MasterKey is read-only.

To create a master key, initialize an instance of the MasterKey class using the constructor that includes a reference to a Database object. Then use one of the methods of MasterKey to actually create the key (Create, Import, Regenerate). Thus, the MasterKey class is required to create a database master key.

https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.masterkey.aspx

George Vobr SSCrazy Eights Points: 9991 More actions · Answer 5

Stephanie Giovannini - Tuesday, February 14, 2017 7:32 AM
Despite both references (including MSDN) stating that the Database class can be used to create a master key, it doesn't appear to be an outright ability of the Database class. Note that the property Database.MasterKey is read-only.
To create a master key, initialize an instance of the MasterKey class using the constructor that includes a reference to a Database object. Then use one of the methods of MasterKey to actually create the key (Create, Import, Regenerate). Thus, the MasterKey class is required to create a database master key.
https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.masterkey.aspx

Nice interesting inventive post, thanks Stephanie for sharing 🙂