Re: OSQL Batch File Problem

It is really, really helpful if you post ONLY one copy of your request.
Posting in multiple locations WITHOUT crossposting loses you the benefit of
our 'bouncing' ideas off of each other.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"J. Baez" <JBaez@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:90E8F840-025C-4FFE-8926-55FC25F94567@xxxxxxxxxxxxxxxx
I have a scheduled task that runs a batch file in windows 2003 server which
is running SQL Server 2000 Enterprise.

The batch file contains the line:

OSQL -i myscript.sql -Umyuser -Pmypassword -Slocalhost -o mytrans.log

the 'myscript.sql' file updates a table with another table of the exact
number of rows.

When the scheduled task runs, the 'mytrans.log' file shows 0 rows were
affected.

If I run this myself from the command line, 22,000 rows are affected which
is correct.

I am guessing there is some sort of permission/authentication issue here.
I
am sending the right username/password for SQL and for windows to run the
task.

Any idea what I could do to fix this?

Thanks,

J. Baez



.

Relevant Pages

  • Re: OSQL Batch File Problem
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... is running SQL Server 2000 Enterprise. ... When the scheduled task runs, the 'mytrans.log' file shows 0 rows were ...
    (microsoft.public.sqlserver.connect)
  • Re: OSQL Batch File Problem
    ... Try fully using fully qualified path for the input file - ... is running SQL Server 2000 Enterprise. ... The batch file contains the line: ... When the scheduled task runs, the 'mytrans.log' file shows 0 rows were ...
    (microsoft.public.sqlserver.security)