[Ad] need a break from coding?
© copyright 29.May.2009 by Paul Bradley filed under Microsoft SQL Server
[Ad] need a break from coding?
A client sent me a copy of their Microsoft SQL Server database to do some work on, I am refactoring some of the tables to increase the overall database performance. After loading the database, I fired up Enterprise Manager to start reviewing certain tables, I always use the Open Table -> Query option so that I can see all the field names, and start running queries on different datasets.
However, all I got was *(All Columns) in place of the fields names, and could not retrieve any of the table column names. The table name was also suffixed with an underscore one (_1). This baffled me for a short while, until I noticed that the database name had a full stop (.) in the title, and figured this might be causing the display bug in Enterprise Manager.
After a quick rename of the production database to remove the full stop, enterprise manager started correctly displaying all the column names within the tables.
About the Author
Paul Bradley is a VB.NET software developer living and working in Cumbria. He provides PHP & MySQL bespoke development services via his software development company, Carlisle Software Limited.
He has over 20 years programming experience.
