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!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s