There is an unsaved comment in progress. You will lose your changes if you continue. Are you sure you want to reopen the work item?
Tables with an ! crash Azure MW when BCP'ing data into SQL Azure
We recently had an issue with migrating a client's database to SQL Azure for an acceleration lab. The database had ~230 tables and kept crashing at some point in the BCP process.
We eventually tracked it down to a table that had the name something like dbo.DELETEME!_OLDTABLENAME
(Don't get me started on what this was doing in the database, but...)
It would seem that a table that has an exclamation mark in it crashes the Azure MW with an unhandled index out side or bounds exception. This ob course makes it pretty hard to track down what triggered the problem.