[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Verify Machine Learning is enabled on Azure SQL Database

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

Verify Machine Learning is enabled on Azure SQL Database.


Date created: June 29, 2019.
 

On this short article we would like to show you how to verify if Machine Learning is enabled on an Azure SQL Database. To do that just run the following statement on the Azure SQL Database:

EXECUTE sp_execute_external_script
@language =N'R',
@script=N'print(31 + 11)';
GO

The image below shows the expected result of the statement:
 




If you by mistake run the above statement on the master database, then you may get the following error message:

Msg 39101, Level 16, State 70, Procedure sp_execute_external_script, Line 1 [Batch Start Line 0]
'sp_execute_external_script' failed because it is not supported in the edition of this SQL Server instance.

 




So make sure you run the statement on a user database.

 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.