[Solved] There is already an object named "D_Product" in the database
When I fix a dimensional modelling issue, re-generate the DLL for my star schema, copy-paste the DLL code to SSMS, i get the following error:
There is already an object named "D_Product" in the database
So solve the problem, you have to delete an existing table before you create a new table.
Use SQL Server Management Studio, connect, select your database, move to the tables folder and delete the existing table with a right mouse click. Then, recreate the table.
Please note: if you delete a dimension table with data in a fact table, you will get an "foreign constraint" error.
Read this forum post here.