Reverse Engineer misses a table

F

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?
 
F

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
 
B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top