That looks good.  thanks

Thanks for those ideas; when I go in tomorrow, I'll check out the "enabled" property.  I hadn't known it was there.

We are running SQL 2000 SP3 Std Ed.

btw--I saw the...

Exact-a-mente

A LEFT JOIN will produce all the records from the "left" table and only the records that match from the "right" table.

Example:

select c.LastName, a.Street1

from Customers c LEFT JOIN Address...

Books On Line has a good section on triggers.  You may want to use an "Instead of" trigger to do your processing on the data before it is inserted into...

The problem must be in permissions, as the following commands work on my network:

--Create the backup from QA on Server A

backup database TestDB to disk='\\ServerB\c$\temp\TestDB.dat'

--Restore the backup on Server B

Restore database TestDB from...

This may be off the point, but it's fairly typical to make the backup locally, and then copy that backup (and restore it if you want to) onto the remote...

There's a couple of caveats to this.  First, email has to be set up on the machine running SQL Server.  Once it is, it's very easy to set up an...

Thanks, I think that maybe the section on the temp files could have helped, but my System pal got here first and fixed the problem.  (Naturally, he did this without...

Yes, I forgot to mention that I re-started the server, and also removed the installation disk and re-inserted it.  I also threw compressed air over my left shoulder and said...

Rebuilding the job from scratch solved the scheduling problem.  Thanks to everyone for the suggestions.

Apparently there was a "date calculation spin" problem, but the easiest thing to do was simply...

I'm aware of the workaround of building a job for each day of the week to avoid "date calculation spin", but I'm taking one more stab at doing it with...

Thanks Rudy.  The job just "died" again, and although I'm getting clues, it's still a mystery.  I checked the SQLAgentOut log and sure enough there were messages involving "date calculation...

lindr, thanks.

I didn't know about the SqlAgent.out file.  I will look there for clues.

Elliott

No end date.  The job should run M-F every minute from 4:00 am to 11:00 pm.