I have some doubts related to SQL server 2008 R2 express 'generate scripts' option.
1)If i select script entire database and all database objects then all objects such as database,permission,table structure,index are created?
2)If i 'select only select specific database objects', and then select only tables(all tables) then does index is created or only table will be created? Also permissions for tables set?(when i tested clustered index are created with primary key,non clustered are not created. So i am not sure what does this option do)
3) If i select both table and user in 'select only select specific database objects' then tables and its permissions with users created?