DB Created with SQL Compare not showing columns in Ent. Mngr

DavidCDavidC Posts: 2
edited September 13, 2006 7:36AM in SQL Compare Previous Versions
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,
Systems Architect / .NET Developer


  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi David,

    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!
Sign In or Register to comment.