SQL Server 2000 Enterprise Manager: Cannot View Columns in Tables Added in View Design
I have a SQL Server 2000 database that does not display a list of columns for any tables in the Designer view in Enterprise Manager. This problem exists whenever you either create a new view or edit existing views. All that appears for each table in the chart is "* (All Columns)". Views otherwise work.
I don't have this problem with other databases.
I ran DBCC CHECKDB on this database and reported 0 errors.
SQL Server log files do not report any errors other than "Error: 15457, Severity: 0, State: 1", which, IIRC, is not actually an error and has nothing to do with this problem.
How can I fix this?
source to share
(cough) um ... this seems to be a bug in Enterprise Manager that happens when the database name completely stops in it.
Check if the database name has a full stop (".") In it, and if it does, restore the database with a different name, omitting the full stop.
(answer from post comment above)
source to share