| title | external scripts enabled Server Configuration Option | Microsoft Docs | ||
|---|---|---|---|
| ms.custom |
|
||
| ms.date | 2017-03-15 | ||
| 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 |
[!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 will be OFF by default. Setup can optionally set this property to true if Advanced Analytics Services is installed.
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.
Execute the following script to enable external scripts.
sp_configure 'external scripts enabled', 1;
RECONFIGURE;
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