We've been promised that the domain name won't change. Hopefully, after the domain migration we won't get the error message of non-existent login.

Thanks

Is this a Windows 2003 issues?    Would you know the url for the MS Documentation of the issue/solutions?

Wonderful.  Worked perfrectly.  Thanks

We don't log ... it is a giant job with steps that run DTS packages, TSQL, and stored procedures.  Any conversion sp_'s out there?

We were using a non key field in pervasive to pull the data.  As a result the pull was taking very long and timing out ... seeming to be a...

Thanks!  This is great ... I think we have enough to get this moving now.  This forum is wonderful!

Could you please give me some idea of the extra code.

In this job Step 1 will run a DTS, step 2 will run another job, step 3 will run another...

We work with a date range so need to go by julian date ... can I say if it is 366 only add 7 days rather than 8?

We hand SQL Server 2000 EM and the BO version is 6.5

We found the ODBC versions out of sync between servers.  We were wondering if not much space on the...

Thanks for the answer Frank!  I do get into the bol as the other person mentioned but most times I find that this forums real work experience feel back is...

Dates aren't date format ... they are text.   If I might ask a stupid questions, what would the convert solution be.

Thanks for all your great and fast feedback.  I'm one...

Thanks for replying so quickly  ... we did have a customer running a wild query.

Thank You!

What select ? ... we get duplicat records for a name (different ages) with SQL Select which is why we are using a cursor.  Can you give me the SELECT...

The master table has more than one record for a person so I only want the one with the max date which is why I am using a cursor ......