Options
DB Created with SQL Compare not showing columns in Ent. Mngr
DavidC
Posts: 2
SQL 2000.
Syncing a 'fulfilled' DB schema to a newly created DB. Attempting to design a query from within Enterprise Manager results in the selected table being shown without ANY columns listed. Doing a SELECT * results in showing there are indeed columns.
Anyone run into this issue - have i provided enough info - anyone got a work around?
Best Regards,
David
Syncing a 'fulfilled' DB schema to a newly created DB. Attempting to design a query from within Enterprise Manager results in the selected table being shown without ANY columns listed. Doing a SELECT * results in showing there are indeed columns.
Anyone run into this issue - have i provided enough info - anyone got a work around?
Best Regards,
David
</DavidChristiansen>
Systems Architect / .NET Developer
Systems Architect / .NET Developer
Comments
No idea. It sounds like a problem with Enterprise Manager to me, or possibly the SQL Server. The table and columns are either there or they aren't and you shouldn't get different results from select top 1 * from as you would in EM's table designer!