Hello, Thanks for the reply, The Job is set up to run as the same domain user as the sql server who is also an administrator on the new box....

I connected remotely to the server using Remote desktop and I noticed that the domain user cannot access the directory I need him to access. This seems to be...

btw, thanks for taking the time to answer , it helps to know at least people are reading the posts

that is owned by sa (dbo) but it turned out to be just as simple...

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q322746

during the hardware change the Path Variable was never updated to reflect the path...

Thanks for the replies. I found an article over on DatabaseJournal on Full Text Indexing, it looks like that just might be a step in the right direction, I'll...

oh.. man I'm so sorry, I posted to the Yukon group This msg is supposed to be in the sql server 2000 group ...

VERY COOL!

thank you...

awesome, thanks for the answer...

I found out I can also use a + .00 so my select would include

(Field1 + .00) / (Field2 +.00) and that also helped to...

We are running an older version of Exchange, I'm almost sure we are not even on 5.5

I Know that it IS not set up to relay, how does a userid and pwd get passed on to the email server? (exchange)

Sure, and I found the problem too ,

the issue is this:

the outer sproc takes parameters to insert/update a status on an ID....

Thanks,

I tried the udf route, but it simply was not feasable. Here is the situation

(*caution more detail*)

The primary sproc calls a *dos* command line utility, I...

simply ingenious [Big Grin]

JourneymanProgrammer, thanks for the ideas, I ended up using a 2nd sproc that does all but the actual INSERT, so for now I'm over this... I'm going to SAVE, your...

there is another way and that is embedding this beast as a vbscript in a DTS and run it from there (or a JOB), but then I have to write...