I have a MS SQL database where the initial developer did not include Primary keys for any of the tables.
I have to retrieve/report information from database and require Primary keys for the tables to do so.
1. Can I add a primary key to each table, without breaking the original applications currently connecting to these tables?
2. Is it possible to add a primary key for each table that can auto-number records retrospectively? and auto-number new records going forward?