I am getting an error when trying to execute SQL Server system procedures such as sp_addLinkedServer and sp_dropserver etc from python script
USE [master]
EXEC master.dbo.sp_dropserver @server=N'DS', @droplogins='bs'
Error :
(15002, b"The procedure 'sys.sp_dropserver' cannot be executed within a transaction.DB-Lib
error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL
Server\n")