I think the major problem here is your using a cursor-based routine inside a database trigger to update a table over a linked server connection.

First, look at changing the cursor-based...

Jordan,

I am just making sure that there isn't something occuring to the database between the time you complete the full backup and the differential.

Please post the complete error message you...

Just to clarify, you are asking if you can run the same SSIS package under two separate jobs, correct?

Sounds like you may have two processes running that want exclusive access to the same file at the same time. What else is running when this job executes?

That is a mighty vague and broad topic. There really isn't room to discuss it fully in a forum post. The gist of it usually forms the basis...

Okay... I missed that when it was...

My brother-in-law as a Lt Colonel in the USAF stationed at the USAFA his last few years in the Air Force. The General he worked for required everyone to...

SSIS (7/6/2009)

---

Guys, I think we are not on the same page here. You got the total right on the isde. But I want the total as one more row below...

SSIS (7/6/2009)

---

We all have these issue once in a while ( please wait until I post my question or just say discussion). I am facing more at the present because...

Just to be sure, are you running anything between these two sets of code?

Care to translate??

Are you saying your trying to return 25+ million rows? Is there a sort on the query? How wide is each record? How fast is your network...

Please show us all the code you use to run the backups back to back in SSMS.

vblllove (7/6/2009)

---

This Payroll System will not be apply to USA System. This will be in Europe. That's why we need a Unique System since the most of Software system are...

Are you sure the full backup completes okay? Is there anything else happening to the database between the full backup and differential backup? Just for s and g's...