0

Trying to set partial containment to an existing database

ALTER DATABASE [EMS_3518_2] SET CONTAINMENT = PARTIAL WITH NO_WAIT

But I'm getting this error:

Msg 12814, Level 16, State 1, Procedure XXXXX, Line 10 [Batch Start Line 0]
The object referenced as 'dbo.XXX' resolves differently in the target metadata collation 'Latin1_General_100_CI_AS_KS_WS_SC' than in the current metadata collation 'SQL_Latin1_General_CP1_CS_AS'.

Not sure how to sort out this issue.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
seba.p
  • 61
  • 1
  • 5
  • Moving from a case-sensitive collation to a case-insensitive one can cause name or resolution conflicts. Check the proc code at line 10. – Dan Guzman May 11 '18 at 22:17
  • @DanGuzman thanks for this! that worked since the table name was uppercase but used in lowercase in the SP... thanks!!! – seba.p May 14 '18 at 15:02

0 Answers0