I recently had a project get corrupted, and I had to revert back to a prior version. When I did this, it appears as though some aspect of the metadata got scrambled. When I open the project, all of the tables and other objects show up. But when I go to deploy any table, regardless of red/black state, the database throws an error "There is already an object named <mytable> in the database." It is as though TX is sending a CREATE statement instead of an ALTER. I can manually delete the table(s) and related function to make this error go away for my one table, but I have hundreds of tables, some of which have many months of history. All of my tables show up in the treeview controls, however when I use the SQL Database Cleanup Tool, none are listed in "Current Project Objects". They are all listed in "Unknown Project". Is there any way to recover from this without having to drop all tables and deploy/execute?
Best answer by Syed Yousuf
View original