Tip #8 – SQL Server Script button

This Blog Article was brought forward from my old blog

This tip is about the SQL Server Management studio again.

Many Dynamics Nav customers and consultants are very new to SQL and the programming language T-SQL.

The SQL Server has solved that with introducting tons of wizards for common tasks like backing up databases and creating users.

Let’s look at one of those (Backup);

With this wizard we can easily create a full, incremental or transaction log backup of the database.

Without going in the details about this wizard I would like to point out the script button

This button exists on a lot of SQL Server wizards. When you push it you get this in your query window

You can use this to either study T-SQL or create your own scripts to reuse or schedule!