DATA Tables missing

yarko

After several invocations, I can no longer select the data table from two local databases I've been working on.

I've checked everything I found here, in knowledge base; restarted SQL server; rebooted my machine.

What could be happening.

Dozens of tables no longer appear, yet I only worked (and only on data content) on one.

Thanks for any pointers.

Bogged down in the middle of user application upgrade (arghhhh).

Yarko

yarko

Don't know what changed; I deleted and recreated the primary key on the table I wanted.

Maybe 4 invocations later this table started showing up in my choices to compare again....

...at least I'm on my way now, but strange.

Daniel Handley

Hi Yarko

Glad the problem resolved itself for you.

If this happens again please let us know so we can look into it.

Regards
Dan

jjmartin1248

I am also missing at least one table in SQL Data Compare.

here are the specs (as found by SQL Compare)

-- Columns
CREATE TABLE [dbo].[WhatIf]
(
[WhatIfId] [int] NOT NULL IDENTITY(1, 1),
[ParentReminderTemplateId] [int] NULL,
[QuestionText] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TargetReminderTemplateId] [int] NOT NULL
)

GO

-- Foreign keys
ALTER TABLE [dbo].[WhatIf] ADD CONSTRAINT [FK_WhatIf_ReminderTemplate] FOREIGN KEY ([ParentReminderTemplateId]) REFERENCES [dbo].[ReminderTemplate] ([ReminderTemplateId])
GO
ALTER TABLE [dbo].[WhatIf] ADD CONSTRAINT [FK_WhatIf_ReminderTemplate1] FOREIGN KEY ([TargetReminderTemplateId]) REFERENCES [dbo].[ReminderTemplate] ([ReminderTemplateId])
GO

Brian Donahue

Hello Jeff,

Thanks for that. I still do not see a primary key/unique index/unique constraint there. Hopefully you haven't set SQL Compare to ignore the primary keys!