- Open up MSSMS
- Right click your database
- Tasks > Generate scripts...
- Script entire database, or select specific objects
- Select destination (normally "Save as script file" for me)
- For schema only, hit Next
- For data, hit Advanced > General > Types of data to script > Data only