Re: OSQL Batch File Problem
- From: "Arnie Rowland" <arnie@xxxxxxxx>
- Date: Tue, 22 Aug 2006 12:57:34 -0700
What is the path to the script file?
Is it in the home folder for OSQL?
--
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:2ADC2B21-B3F0-45ED-A833-A07A9D9F6A7A@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
.
- Prev by Date: in sql server 2000 when you issue a alter table to add new column, can you specifiy the order? meaning i want that column to be between existing columns, not at the last
- Next by Date: Re: in sql server 2000 when you issue a alter table to add new column, can you specifiy the order? meaning i want that column to be between existing columns, not at the last
- Previous by thread: Re: OSQL Batch File Problem
- Next by thread: Re: tracking SPID back to the user or client
- Index(es):
Relevant Pages
|
