How can we help you today? How can we help you today?

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

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
DavidC
0

Comments

1 comment

Sort by
  • Brian Donahue
    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!
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.