| title | external scripts enabled Server Configuration Option | Microsoft Docs | ||
|---|---|---|---|
| ms.custom |
|
||
| ms.date | 08/03/2017 | ||
| ms.prod | sql-server-2016 | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 9d0ce165-8719-4007-9ae8-00f85cab3a0d | ||
| caps.latest.revision | 9 | ||
| author | BYHAM | ||
| ms.author | rickbyh | ||
| manager | jhubbard | ||
| ms.workload | On Demand |
[!INCLUDEtsql-appliesto-ss2016-xxxx-xxxx-xxx_md]
Use the external scripts enabled option to enable the execution of scripts with certain remote language extensions. This property is OFF by default. When Advanced Analytics Services is installed, setup can optionally set this property to true.
You must enable the external script enabled option before you can execute an external script using the sp_execute_external_script procedure. Use sp_execute_external_script to execute scripts written in a supported language such as R. In [!INCLUDEssSQL15], [!INCLUDErsql_productname] is comprised of a server component installed with [!INCLUDEssSQL15], and a set of workstation tools and connectivity libraries that connect the data scientist to the high-performance environment of [!INCLUDEssNoVersion]. Install the Advanced Analytics Extensions feature during [!INCLUDEssNoVersion] setup to enable the execution of R scripts. For more information, see Installing Previous Versions of SQL Server R Services.
To enable external scripts, execute the following script:
sp_configure 'external scripts enabled', 1;
RECONFIGURE WITH OVERRIDE;
You must restart [!INCLUDEssNoVersion] to make this change effective.
sp_configure (Transact-SQL)
RECONFIGURE (Transact-SQL)
sp_execute_external_script (Transact-SQL)
SQL Server R Services