search

google-code-export / pymssql

Automatically exported from code.google.com/p/pymssql
GNU Lesser General Public License v2.1
0 stars 0 forks source link

System proc SP_CONFIGURE #96

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
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 reported on code.google.com by Corrupte...@gmail.com on 21 Jul 2012 at 3:52

GoogleCodeExporter commented 9 years ago 
anyone?

Original comment by Corrupte...@gmail.com on 6 Aug 2012 at 3:42

GoogleCodeExporter commented 9 years ago 
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?

Original comment by msabr...@gmail.com on 7 Jan 2013 at 5:52

GoogleCodeExporter commented 9 years ago 
Not enough info to act on this

Original comment by msabr...@gmail.com on 7 Aug 2013 at 7:09