Tip #8 - SQL Server Script button

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!

Comment List