sometimes, we need at all the tables should contain a primary key, like in replication.
I create script for this. You can generate the statements or execute them as per your requirements.
Execute the sp with proper flag( 0/1 ) .
1. First Execute the sciprt .and then
2. EXECUTE spAddPrimaryKey 0,1,0,0,0 [ AS PER UR REQUIREMENT]
I think i will help you.
I m waiting ur resonses and valuable suggestions.