Reverse Engineer misses a table

[frankm]

I tried to reverse engineer a group of tables on a SQL Server 2000 sp3a
system.
It actually cannot see one of the tables.
I am able to script it etc - it has data - it is owned dbo.
But it isn't seen by Visio at all. I can see it, access it etc through EM
and SMS.
I'm running Viso Professional 2003 sp2.

Any ideas?

 

[Jay]

Can you post the ddl for the table?

 

[frankm]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_Diff_BDates](
[loadid] [char](7) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,
[prtnum] [char](14) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,
[Load_Id] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,
[partnum] [varchar](14) COLLATE SQL_Latin1_General_CP1_CI_AI NULL,
[Diff] [int] NULL,
[Birth_Date] [nchar](20) COLLATE SQL_Latin1_General_CP1_CI_AI NULL,
[Prod_date] [nchar](20) COLLATE SQL_Latin1_General_CP1_CI_AI NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

 

[Barb Way]

Is the table owned by DBO or another SQL entity? We only see DBO objects
in the reverse engineering input.

Barb Way
Product Support - Visio
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.