From the course: Complete Guide to Advanced SQL Server

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Enable script execution in SQL Server

Enable script execution in SQL Server - SQL Server Tutorial

From the course: Complete Guide to Advanced SQL Server

Start my 1-month free trial Buy for my team

Enable script execution in SQL Server

“

Now that the computer has restarted, we can load up SQL Server Management Studio and verify that everything works. Make sure that you log in to the server with a user account that has administrator privileges. Then I'm going to start up a new query window, and I need to check the status of my server by running the stored procedure called sp_configure. I'll execute this query here. And the value that I'm looking for is on the row that says, "External scripts enabled." It's line number ten here. The current config value is set to zero, and that's because the default is to not allow external code to run for security purposes. In order to execute Python code, we need to enable this feature. We do that by executing sp_configure. Then inside of single quotation marks, we'll type in the words, "External scripts enabled," and then a comma and the number 1. I'll come down to line number two and type in, "Reconfigure with override." I'll execute these two lines to change the settings on my…

Contents