Category Archives: Machine Learning

How to enable sp_execute_external_script to run R script in Sql server?

================ Error ===================

Msg 39023, Level 16, State 1, Procedure sp_execute_external_script, Line 1 [Batch Start Line 9]

‘sp_execute_external_script’ is disabled on this instance of SQL Server. Use sp_configure ‘external scripts enabled’ to enable it.

Msg 11536, Level 16, State 1, Line 10

EXECUTE statement failed because its WITH RESULT SETS clause specified 1 result set(s), but the statement only sent 0 result set(s) at run time.

========================= fix ===========================

when enabled, you will see the config_value changed from 0 to 1

Note: SQL Server Service has to be restart for this to take into effect!