Just a thought but change the agent profile to use smaller bcp batch size and a higher login time out and a higher query time out. You might also want...

use datepart function and return the time portions and order by these

Does the column that is being used in the bookmark lookup have an index

you could use the isdate() function:

Select * from table where isdate(column) = 1

you need the personal addition of sql 2000, just pop the cd in and away you go.

Presumably if he is going to check that you are doing your job correctly he should know what he is doing. If that is the case he should be a...

pretty much out of ideas on this, you could look at using smtp mail via http://www.sqldev.net/xp/xpsmtp.htm I use this on some of my servers and find it less problematic than...

Did you craete the package on another machine and then saved it to the server?

you need to remote desktop into the server and edit the dts, the mapi profile is local. If you try and edit package on own pc, it picks up your...

you could insert into a process table and de-dupe before final import into production table. Could write process whereby you save the offending records to examine later.

Don't know if this is what is actualy causing the issue, but to control the ammount of cpus an sp uses use the maxdop hint

go to replication monitor and expand and there you will fine replication alerts

could think of a few rather un pc answers but don't think that will help your database issue

have you tried searching the registry?

try this link, i am assuming msde adds reg entries as well:

http://support.microsoft.com/?id=290991#4