How can we help you today? How can we help you today?

Error when documenting a particular table

I get the following error when documenting a database unless I deselect a particular table. This happens in multiple SQL instances for the same table.

Preview cannot be displayed
An exception has occurred while trying to display the preview. The error message is:
unexpected token: [";",<673>,line=23,col=2] [char=884]

Serious error? Send report.


The the table creation script generated from SSMS follows.

Any help you could offer would be greatly appreciated.

USE [xxxx]
GO

/****** Object: Table [dbo].[content_stream_owner] Script Date: 7/23/2014 8:44:10 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[content_stream_owner](
[content_stream_owner_id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[mall_id] [int] NULL,
[base_tenant_id] [int] NULL,
[tenant_id] [int] NULL,
[content_stream_data_id] [int] NOT NULL,
CONSTRAINT [pk_content_stream_owner] PRIMARY KEY CLUSTERED
(
[content_stream_owner_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[content_stream_owner] WITH CHECK ADD CONSTRAINT [fk_content_stream_owner->base_tenant] FOREIGN KEY([base_tenant_id])
REFERENCES [dbo].[BASE_TENANT] ([BASE_TENANT_ID])
GO

ALTER TABLE [dbo].[content_stream_owner] CHECK CONSTRAINT [fk_content_stream_owner->base_tenant]
GO

ALTER TABLE [dbo].[content_stream_owner] WITH CHECK ADD CONSTRAINT [fk_content_stream_owner->content_stream_data] FOREIGN KEY([content_stream_data_id])
REFERENCES [dbo].[content_stream_data] ([content_stream_data_id])
GO

ALTER TABLE [dbo].[content_stream_owner] CHECK CONSTRAINT [fk_content_stream_owner->content_stream_data]
GO

ALTER TABLE [dbo].[content_stream_owner] WITH CHECK ADD CONSTRAINT [fk_content_stream_owner->mall] FOREIGN KEY([mall_id])
REFERENCES [dbo].[MALL] ([MALL_ID])
GO

ALTER TABLE [dbo].[content_stream_owner] CHECK CONSTRAINT [fk_content_stream_owner->mall]
GO

ALTER TABLE [dbo].[content_stream_owner] WITH CHECK ADD CONSTRAINT [fk_content_stream_owner->tenant] FOREIGN KEY([tenant_id])
REFERENCES [dbo].[TENANT] ([TENANT_ID])
GO

ALTER TABLE [dbo].[content_stream_owner] CHECK CONSTRAINT [fk_content_stream_owner->tenant]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The primary key column for the table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'COLUMN',@level2name=N'content_stream_owner_id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The optional mall ID of the owner.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'COLUMN',@level2name=N'mall_id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The optional base tenant ID of the owner.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'COLUMN',@level2name=N'base_tenant_id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The optional tenant ID of the owner.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'COLUMN',@level2name=N'tenant_id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The idea of the content stream data row owned by this owner.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'COLUMN',@level2name=N'content_stream_data_id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'The primary key of the table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'CONSTRAINT',@level2name=N'pk_content_stream_owner'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'This is a foreign key into the base tenant table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'CONSTRAINT',@level2name=N'fk_content_stream_owner->base_tenant'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'As a foreign key into the mall table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'CONSTRAINT',@level2name=N'fk_content_stream_owner->mall'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'This is a foreign key into the tenant table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'content_stream_owner', @level2type=N'CONSTRAINT',@level2name=N'fk_content_stream_owner->tenant'
GO
bgsisson
0

Comments

1 comment

  • Brian Donahue
    Red Gate is attempting to work on this already but if any SQL Doc users have had the same issue we would like to hear from you!
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.