Generate script in SQL server With Data

To generate script in SQL server with data you need to follow the following step

1. Open SQL server management studio
   
2. expand database
3. Right-click in the database on which you want to generate a script with data
4. Click on Task
5. Click on generate script
   
6. choose the option with script entire database and all database objects and click on next
   
7. Click on the advanced option
   
8. Choose SQL server version for which version you want to generate script
   
9. select Schema and data option of Types of data to script
10. 
    choose true on Script Triggers
    
11. chose a location where you want to generate a script file
12. Click next 
13. 
    after finish, all tasks click on the finish 
    

your script will save in to drive