Mehernosh (8/8/2013)

---

Hi,

If this helps - you can script the database items using the Generate Scripts option for your selected database.

[p]

1. Right click on your database in SSMS, select Tasks and then Generate Scripts.

2. Select the "Specific database option" for scripting.

3. Select your object viz Tables , Views, Stored Procedures, UDF et al.

4. Importantly in the next step of the wizard click the Advanced Button.

5. Change the "Script for server version" in accordance to your needs.

6. Change the "Types of data to script" to Schema and Data or select as required.

7. Have a look through all the other options if required.

8. Save the results in a file or clipboard or New query.

9. Review your selections &

10. You will have your script ready.

[/p]

Hope this helps.

🙂