Hello, I have a problem, I need to execute the next query
EXECUTE SP_CONFIGURE 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
GO
EXECUTE SP_CONFIGURE 'xp_cmdshell', '1'
RECONFIGURE WITH OVERRIDE
GO
EXECUTE SP_CONFIGURE 'show advanced options', 0
RECONFIGURE WITH OVERRIDE
GO
firts execute that to activate the xp_cmdshell and letter again but with 0 to disactivate, but how can i execute that? i dont have problem with others querys.
Thaks I hope anyone can help me.
PD. congratulations for the developers of this library ;)
You are trying to execute those with pymssql? Can you paste your Python code and the errors you're getting? Do the same queries work OK in SQL Server Management Studio?
From CorruptedIbanez on July 20, 2012 20:52:04
Hello, I have a problem, I need to execute the next query
EXECUTE SP_CONFIGURE 'show advanced options', 1 RECONFIGURE WITH OVERRIDE GO
EXECUTE SP_CONFIGURE 'xp_cmdshell', '1' RECONFIGURE WITH OVERRIDE GO
EXECUTE SP_CONFIGURE 'show advanced options', 0 RECONFIGURE WITH OVERRIDE GO
firts execute that to activate the xp_cmdshell and letter again but with 0 to disactivate, but how can i execute that? i dont have problem with others querys.
Thaks I hope anyone can help me.
PD. congratulations for the developers of this library ;)
Original issue: http://code.google.com/p/pymssql/issues/detail?id=96