SQL Server 2000 Enterprise Manager: Unable to view columns in tables added to View designer -
I have a SQL Server 2000 database that will not display the column list for a table in the "Designer" view in the Enterprise Manager This problem occurs when creating a new view or editing the current view is all the "" (all columns) "" displayed for each table in the diagram. The ideas work otherwise.
This problem is not with any other database.
I checked DBCC on this database and it reported 0 errors.
SQL server log file "Error: 15457, Seriousness: 0, State: 1" Even the other error does not report that IIRC is not really an error and there is nothing to do with this problem.
How can I fix this?
(cough) Um ... this seems to be a bug in the enterprise manager's name then When the database name stops full.
Check that the database name is full stop ("."), And if it is in, restore the database with a different name, complete Excluding the stop
(The answer descended from the comment above)
Comments
Post a Comment