Is each example beside #4 (two packages) showing a package along it entire voyage with all stops?

#1 shows one package with two stops and then its final destination?

I would query sysobjects, syscolumns, sysforeignkeys, sysindexes and sysindexkeys to get that info. Build from this:

Select

l_so.name

,l_sc.name

,l_sik.indid

,l_sik.keyno

From dbo.sysobjects...

The entry will conatin statistics for the index.  Can you post an example of the data you are viewing in question? Are you looking at WU_% entries?

The derived table will create a list of customers that have transactions older than a year thus omitting the new customers within the year, but will still return transactions...

This will give you a 1 for errors and a 0 for success. Now I am assuming you are trying to log all this activity without using isql...

Hold on the return val of 0 is coming from the sp_executesql. 

What version of MS SQL Server are running?

On MS SQL Server 2000 sp3a This will raise the same error and return a value of 1

Check into Set ArithAbort.

Can you post the SQL?

Convert the @StartTime, @EndTime, @DayTime to ticks and then test if the @DayTime >= @StartTime And <= @EndTime.

If you store shift hours convert them as they apply to that day.

Set...

Lastley could you provide the update statement that fails!

How do you know the app is using SQL Authentication?

Select 'Exec sp_change_users_login ''Update_One'','''+su.name+''','''+su.name+''''

From master.dbo.syslogins sl

 Inner Join dbo.sysusers su

  On sl.name = su.name

Where su.uid > 2

Why wont sp_change_users_login work for you? What are your permissions on the server/database?

If you have 'sysadmin' role I recommend using 'auto fix'. If you are dbo in the database referenced...

Are you wantimg to do this from within a Stored Procedure?