I have a SQL database that has several tables for different clients. What I want to do is take the tables associated with each client and place them into their own database. The problem is, when I export the tables from one database to the other, each table's ID column loses its "identity". In other words, I have to go back into each table and change the identity from NO to YES in the ID column. Another problem I'm having is when I generate a SQL script to recreate the Stored Procedures. When I recreate the procedures, I have to go in each one individually and set the permissions again. Is there a way to take care of these two problems simply without having to do each table and procedure by hand? As always, thanks!