Python in MSSQL

Scripts might run as different user (with different permissions)

Enable external scripts (might already be enabled)

EXEC sp_configure 'external scripts enabled', 1
RECONFIGURE WITH OVERRIDE
EXEC sp_execute_external_script @language =N'Python', @script = N'import os; os.system("whoami");';

Last updated