Post reply

osql suppress all output without the -o parameter

  • May 8, 2003 at 10:23 am

    #81898

    Other than using the -o parameter and the 'xp_cmdshell "cmd", no output', is there a way to suppress all output from an osql command?

  • May 8, 2003 at 11:59 am

    #456570

    Use greater than (>) comparison operator to direct output to a file from osql.

    Edited by - Allen_Cui on 05/08/2003 12:25:19 PM

  • May 8, 2003 at 12:42 pm

    #456574

    Check this out:

    osql -S[servername] -dmaster -E -Q"exec master..xp_cmdshell 'osql -w300 -E -S[servername] -dmaster -Q"""select * from sysdatabases"""',NO_OUTPUT"

  • May 8, 2003 at 10:43 pm

    #456622

    Just redirect to NUL.

    e.g.

    osql (...whatever...) > NUL

    Jay Madren


    Jay Madren

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply