SQL 2025 master class LAB 15 SQL Launchpad

sp_configure 
     @configname = 'show advanced options'
    ,@configvalue = 1
GO
RECONFIGURE WITH OVERRIDE;
GO
 
sp_configure 
     @configname = 'external scripts enabled'
    ,@configvalue = 1            
GO
RECONFIGURE WITH OVERRIDE;
GO

--restart sql and launchpad 

EXEC sp_execute_external_script  
    @language = N'Python',  
    @script = N'print("Hello World from the Launchpad service!")'; 

 --with thanks and acknowledgement to https://sqlchitchat.com/tag/launchpad/

 --Housekeeping

 use MASTER

sp_configure 
     @configname = 'show advanced options'
    ,@configvalue = 1
GO
RECONFIGURE WITH OVERRIDE;
GO
 
sp_configure 
     @configname = 'external scripts enabled'
    ,@configvalue = 0            
GO
RECONFIGURE WITH OVERRIDE;
GO