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.