Hi all I have a job running, it basically executes a store procedure. Store proc contains some sql queries that insert data from one server to other. Job runs fine, but sometimes it comes up with following error Executed as user: NT AUTHORITYSYSTEM. OLE DB provider 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::InsertRow returned 0x80004005: ]. [SQLSTATE 01000] (Error 7300). The step failed. I really don't understand the behavior (works fine someday , and comes with error some other day) Thanks heaps Whenever you fall, pick something up.