1. I have 1 table "EmpTable" having 5 columns,2 indexes and 2 triggers. I want to add new column to "EmpTable" at 3 position. How I can add the new column? What is a flexible approch for this? Table Structure is as follow EmpTable - col1 col2 col3 col4 col5 I want the structure as follow col1 col2 ColNEw col3 col4 col5 2.What is the difference between roles and groups 3. There are two set of user,running on two different set of procedures How to give a permissions to user on procedures Ex - Database DB1 having 100 procedures. user1 uses 50 procedures out of 100 and user2 uses remaining 50 procedures. 4. Database DB1 having 100 procedures. Also there are 3 groups Gr1,Gr2 and Gr3 Gr1 have 2 user uses 50 procedures out of 100 and Gr2 have 5 user uses remaining 50 procedures. But I want to add Gr1 & Gr2 to Gr3 so Gr3 can have the permission to all 100 Procedures. How I can add Gr1 & Gr2 to Gr3. 5. How cache deadlocking is handle in stored procedures? 6. concept of @@TranCount 7. What is Nested transaction Plz give me some idea for all the above question.