Visual Studio 2500 - Dataset Configuration Wizard error
I used Packager to create a package that updates a customer database. I created a backup of the client database in SQL express and restored the client database with a rename. So that I can use it as the develop database. This all works fine and the application created in VS2005 also works fine.
However today I wanted to add a new table to the dataset in VS2005. I start the dataset configuration wizard and all my tables appear twice in the list of tables. Once with the original name and once with the prefix dbo. For example: Customer and dbo.Customer.
The tables with the dbo. prefix are marked with a Red Cross in the checkbox. Hovering over them display the error message: "Element .. in the dataset references an object missing from the database. "
The tables without the dbo. prefix are not marked. When I mark these tables VS2005 indicates that the table will be renamed to Customer1.
The same issue applies to all the views in the database.
Is there a way to solve this problem without having to recreate the entire dataset?