This error came up as soon as she tried to open a new diagram (none existed before). I can't figure out what column it thinks is wrong if it never even got so far as creating the diagram.
One word of warning with these tools is that if you make a change and save it, you are changing your database, the model equals the database. So, if you make a change to the database via a CREATE, ALTER or DROP statement that will reflect in the data model, and if you drop a table in the data model, you will not find it in your database. So be careful and understand the ramifications.
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning
Related Q&A from Jeremy Kadlec
Adding non-clustered indexes to SQL Server columns and tables frequently queried is possible. Learn how to add non-clustered indexes to SQL Server ... Continue Reading
Learn how to view a query execution plan in SQL Server with SQL Server Management Studio or Query Analyzer. Review and decrease query plan sub tree ... Continue Reading
Want to change the collation to SQL Server 2005 standards after upgrading databases from SQL Server 2000? Learn the best approach involving DTS and ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.