{"id":819,"date":"2015-04-18T15:16:47","date_gmt":"2015-04-18T09:16:47","guid":{"rendered":"http:\/\/dotnetsql.info\/net-sql\/?p=819"},"modified":"2015-07-09T14:37:24","modified_gmt":"2015-07-09T08:37:24","slug":"server-management-studio-scripting-on-tsql-commands","status":"publish","type":"post","link":"http:\/\/dotnetsql.info\/net-sql\/index.php\/server-management-studio-scripting-on-tsql-commands\/","title":{"rendered":"SQL Server Management Studio scripting on TSQL commands"},"content":{"rendered":"

Scenario<\/strong><\/p>\n

With SQL Server Management Studio you have the ability to do just about everything you can do using T-SQL commands.\u00a0 One problem with using the GUI is that it is difficult to remember everything you clicked on to reproduce the behavior a second time.\u00a0 Another issue is that most of what you do through the GUI is done immediately which may not always be the best scenario.\u00a0 How can I capture what SQL Server is doing so I can reproduce the behavior or run the commands at a later time.<\/p>\n

Solution<\/strong><\/p>\n

A nice addition to SQL Server Management Studio is the ability to script out most of the commands and operations that you can do through the GUI.\u00a0 Let’s take a look at doing a database backup as an example.\u00a0<\/p>\n

Let’s say we want to backup the AdventureWorks database, but we don’t want to run the backup immediately we just want to generate the code.\u00a0 One option would be to use Books Online and look at the syntax and another is to let the GUI generate the code.<\/p>\n

Letting the GUI produce the script<\/strong><\/p>\n

The first thing we need to do is go through the steps of creating a backup via the GUI.\u00a0 To do this we just right click on the database name and select Tasks -> Back Up.\u00a0 Once we have selected all of the parameters that we want for our backup, click on the “Script” option in the top middle of the window.<\/p>\n

If you click on the down arrow next “Script” you will see four options.<\/p>\n