Hi Steph,

Let's start with Reconfigure. The options we are setting here can be configured to be turned on. For example. If you execute:

sp_configure 'show advanced options', 1;

Then execute sp_configure you will see the the config_value is set to 1, however the run_value is not. Without the Reconfigure statement you will only be setting the config_value. To set the run_value you need to either execute the reconfigure statement or restart your server.

Knowing that let's look at the first line.

sp_configure 'show advanced options', 1;

This will set the config_value to show you more options when you run sp_configure. To enable it right now you can run the Reconfigure statement.

The GO statement signals the end of a batch.

The next line: sp_configure 'clr enabled', 1;

This will set the config_value for that option.

Next, again, we run the reconfigure statement to enable the feature.

I hope this helps. 🙂

Cheers