Home Forums SQL Server 2005 Development how to run this query in window authentication mode RE: how to run this query in window authentication mode

  • or use SQLCMD with the -E flag?

    http://msdn.microsoft.com/en-us/library/ms162773.aspx

    sqlcmd

    [{ { -U login_id [ -P password ] } | –E trusted connection }]

    [ -z new password ] [ -Z new password and exit]

    [ -S server_name [ \ instance_name ] ] [ -H wksta_name ] [ -d db_name ]

    [ -l login time_out ] [ -A dedicated admin connection ]

    [ -i input_file ] [ -o output_file ]

    [ -f ] ]

    [ -u unicode output ] [ -r [ 0 | 1 ] msgs to stderr ]

    [ -R use client regional settings ]

    [ -q "cmdline query" ] [ -Q "cmdline query" and exit ]

    [ -e echo input ] [ -t query time_out ]

    [ -I enable Quoted Identifiers ]

    [ -v var = "value"...] [ -x disable variable substitution ]

    [ -h headers ][ -s col_separator ] [ -w column_width ]

    [ -W remove trailing spaces ]

    [ -k [ 1 | 2 ] remove[replace] control characters ]

    [ -y display_width ] [-Y display_width ]

    [ -b on error batch abort ] [ -V severitylevel ] [ -m error_level ]

    [ -a packet_size ][ -c cmd_end ]

    [ -L [ c ] list servers[clean output] ]

    [ -p [ 1 ] print statistics[colon format]]

    [ -X [ 1 ] ] disable commands, startup script, enviroment variables [and exit]

    [ -? show syntax summary ]

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005