February 13, 2017 at 10:04 pm
Comments posted to this topic are about the item The SMO Database Class
February 13, 2017 at 11:39 pm
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”
February 14, 2017 at 1:22 am
Stewart "Arturius" Campbell - Monday, February 13, 2017 11:39 PMInteresting question, thanks Steve.
Had to read up on this
+1
February 14, 2017 at 6:20 am
I had to research it as well. I like the questions where I learn something, so thanks Steve.
February 14, 2017 at 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
February 14, 2017 at 4:39 pm
Stephanie Giovannini - Tuesday, February 14, 2017 7:32 AMDespite 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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy