You'll have to excuse me, but I'm much more of a visual person, could you show us the various forms the query could take based on the various parameters passed?

What application are you tracing? There are several third-party applications that use server-side cursors in this fashion, one such application is PeopleSoft.

I'm having a little trouble visualize what you are attempting to accomplish, and I have looked at this several times over the past week. If you could provide the...

Here is an alternative solution. I added an additional column to show you what was being returned.

declare @customers table (cus_id int);

declare @orders table (cus_id int, order_date datetime);

insert into @customers...

Database Mail is not supported in the Express Edition, nor is SQL Server Agent.

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?