6 Replies Latest reply on Jul 9, 2008 12:35 PM by Anthony Bove

    osql sp_configure grammar

    Anthony Bove

      Anyone come up with a good grammar to use (existing or new) for MS-SQL osql sp_configure queries? The name space value somewhat comes close, but for some reason it doesn't show the run_value, which is the only one I care about. Another problem is if the property being queries has spaces in it (i.e. 'xp_cmdshell' is OK, but 'c2_audit' becomes a problem as it is displayed as 'c2 audit mode'). Here's an example of what I'm trying to run:


      osql -U -Q"EXEC sp_configure 'xp_cmdshell'"


      Regards, Tony