Nothing worked, in the end i deleted all the conflict tables and the replication tables in the database, dettached it, uninstalled SQL server, reinstalled it, and reattached it... not ideal,...
Done all of that, subscriptions went a long time ago, issued the instruction to drop the publication as per BOL and my own experience.. but it comes back to the...