Thanks for your post. Either I don't understand the problem correctly or haven't gone through the same steps as you have, but I cannot reproduce the issue.
I have the following schema collection:
- Code: Select all
CREATE XML SCHEMA COLLECTION [dbo].[SQLCompareReport]
AS N'<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" ...
CREATE TABLE [dbo].[SQLCompareReports]
[id] [int] NOT NULL IDENTITY(1, 1),
[filename] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[report] [xml] (CONTENT [dbo].[SQLCompareReport]) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
In the documentation for the XML Schema Collection "SQLCompareReport", the "used by" section reports [dbo].[SQLCompareReports].
If you have some script that will reproduce the issue, or if maybe the database is actually operating in compatibility mode 80, please let me know.