We review all DML and DDL before release to QA, etc.

It does seem to be related to a sort that never completes. I'm a DBA and don;t know much about the Access application. It's probably a fairly recent...

I'm 61, I like where I work now and I hope so.

Our issue is that we are still on Windows Server 2003, in most cases. One of the obstacles to resolving that has been that we use numerous SAN clones/snapshots...

Did you ever figure this out? We're having a similar issue. Thanks.

This support article discusses this issue.

http://support.microsoft.com/kb/953748

Are there error messages when the job fails?

In the wizard there is a checkbox for saving it or not. Yo then have to choose between saving it in SQL Server or the file system. If...

If you're moving to 64-bit servers you should probably use 64-bit SQL Server unless there is some compelling reason not to.

If it's not a lot of data I would probably drop the article then add it the way that it should be. After that, run the snapshot job so...

And it can be slow and require additional space when compared to offline.

CREATE TABLE Timecards

(staff_id CHAR(9) NOT NULL PRIMARY KEY

REFERENCES Personnel (staff_id)

work_week CHAR(10) NOT NULL

CHECK (work_week LIKE '[12][0-9][0-9][0-9]W[0-5][0-9]'),

PRIMARY KEY (staff_id, work_week),

work_hrs DECIMAL (5,2) DEFAULT 0.00 NOT NULL);

Aren't there multiple primary keys...

I would try restarting the instance and see if that resolves the issue.

I did a Google search for "Mail configuration information could not be read from the database." and several decent links came back. If you haven't done that, give it...

Have you tried putting the distribution database somewhere else, which you probably should be doing anyway.