problem with running scripts against sql2k

Help or sugestions needed !
I have a remote dedicated server with sql2k running on it and am having
problems with running vbscrips from taskscheduler and updating tables etc.
Task scheduler shows running (but does not go away) but is not actually
updating tables.
If I run the scripts logged in as administrator and run from command line
they work ok and update tables from vbscript login and operation is working
ok.
if I run from task scheduler they don't. either manually or at scheduled
times.
I have other scripts using the same login to sa that are working ok and
firing from taskscheduler.
Regards
DonIf you replace the update with select, does it work.
You might want to turn on profiler and see what is going on.
-oj
RAC & QALite!
http://www.rac4sql.net
"Don Grover" <spamfree@.assoft.com.au> wrote in message
news:uUsuJ8nxDHA.2448@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Help or sugestions needed !
> I have a remote dedicated server with sql2k running on it and am having
> problems with running vbscrips from taskscheduler and updating tables etc.
> Task scheduler shows running (but does not go away) but is not actually
> updating tables.
> If I run the scripts logged in as administrator and run from command line
> they work ok and update tables from vbscript login and operation is

---

working

quote:

---

> ok.
> if I run from task scheduler they don't. either manually or at scheduled
> times.
> I have other scripts using the same login to sa that are working ok and
> firing from taskscheduler.
> Regards
> Don
>
>

---

|||What i found and I dont know why it is so but !
I had turned off allow Terminal services for the username that was running
the script and it worked when turned on.
This user name is only for running vbscrips from task scheduler so I did not
need it but looks like I do !
Don
"oj" <nospam_ojngo@.home.com> wrote in message
news:OA7w7loxDHA.2452@.tk2msftngp13.phx.gbl...

quote:

---

> If you replace the update with select, does it work.
> You might want to turn on profiler and see what is going on.
> --
> -oj
> RAC & QALite!
> http://www.rac4sql.net
>
> "Don Grover" <spamfree@.assoft.com.au> wrote in message
> news:uUsuJ8nxDHA.2448@.TK2MSFTNGP12.phx.gbl...
etc.[QUOTE]
line[QUOTE]
> working
>

---