A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
SQL Server 2022 RTM does not document R and Python as automatically created rows in sys.external_languages; verify the actual database because that view records database-scoped external-language registrations, while R and Python are reserved names handled through Machine Learning Services.
Run this in the database being examined:
SELECT
DB_NAME() AS database_name,
external_language_id,
language,
create_date,
principal_id
FROM sys.external_languages
ORDER BY language;
sys.external_languages returns one row for each external language registered in the current database. Microsoft documents R and Python as reserved names for which an external language cannot be created under those exact names; it does not state that SQL Server 2022 seeds corresponding rows automatically.^1^
Therefore:
- An empty result on a fresh database is not evidence of a failed R/Python installation.
- Rows created for custom Language Extensions are database-scoped and can differ between databases.
- Do not attempt
CREATE EXTERNAL LANGUAGE [R]or[Python]; both names are reserved.^2^ - Catalog rows and runtime availability are separate questions. Querying
sys.external_languagesalone does not establish whether built-in R/Python execution is configured.
SQL Server 2022 runtime behavior
Beginning with SQL Server 2022, SQL Setup no longer installs the R, Python, or Java runtimes. To use R or Python, install Machine Learning Services and Language, install the desired custom runtime and packages, register the runtime with the instance, enable external scripts, and restart the service.^3^
Check whether external-script execution is enabled with:
EXEC sys.sp_configure N'external scripts enabled';
A configured installation should report config_value = 1 and run_value = 1. Runtime functionality must then be tested directly—for example:
EXEC sys.sp_execute_external_script
@language = N'Python',
@script = N'import sys; print(sys.version)';
A successful call verifies Python execution; it does not depend on a user-created Python row in sys.external_languages.
In short, reserved names do not imply default catalog entries, and the available documentation does not establish that SQL Server 2022 RTM build 16.0.1000.6 creates such rows. The authoritative result for a particular installation is the per-database query above, while runtime support must be verified separately through Machine Learning Services.
References