Timeline for Contained DB Collation error
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 2, 2015 at 12:11 | comment | added | Tom | Unfortunately scripting the ALTER Database statement is only a single command when changing to contained. I will try profiler however. | |
| Nov 26, 2015 at 21:26 | comment | added | RLF | @Tom - Added details based on a better understanding of your issue. Most SSMS GUI actions can be used to generate a script. If you use the GUI for that function, generate the script and paste it into a query window. That will give you a chance to examine the commands and perhaps make a needed change to the script. | |
| Nov 26, 2015 at 19:44 | history | edited | RLF | CC BY-SA 3.0 |
Clarified to match Tom's situation, and clarify Catalog and Data collation differences.
|
| Nov 26, 2015 at 14:52 | history | edited | RLF | CC BY-SA 3.0 |
updated with related details from MSDN on Contained Database Collations.
|
| Nov 26, 2015 at 14:14 | comment | added | Tom | Yes, in my case I am just using the GUI to change the database to partially contained and getting the said error. I am at a loss. | |
| Nov 26, 2015 at 13:48 | history | answered | RLF | CC BY-SA 3.0 |