Reindexing is scheduled during the weekend.  Log backup twice a day and full db backup nightly.  I been profiling the server for 3 days and no activities.  But log is...

Is there some configuration that need to be setup or enable for sp_OA procedure to work?  I have a similar procedure that was written by some consultant, and it work...

great suggestion.  Thanks

Thanks Terry.  That fixed it.

Look good.  Thanks..

Well, thanks for the "soapBox." It answers my question. 😐

10 15127 1 Collection <----- out of order

10 is Runit and it's in an Integer type.

This column is not in the sort order criteria. But from the different backup...

Here's the sample output from the Original DB:

(the data on RUnit column should be in order from 1-15 but for some reason it start at 10)

RUnitContrct TypeContractText

176521Collection

276521Collection

376521Collection

476521Collection

576521Collection

676521Collection

776521Collection

1076521Collection

1176521Collection

1276521Collection

1376521Collection

1476521Collection

1576521Collection

10151271Collection <----- out of...

Chris:

1. SQL Server 2000 with SP3a

2. Here's the query:

select ...

from tbl_lob_contracttype a

left outer join tbl_rates b on a.contractid = b.contractid

and a.lob_contracttypeid = b.rtype

left outer join tbl_lookup_contracttype c...

Thanks for the info. Unfortunately, I didn't have a chance to test this setup. I uninstall MSDTC and reconfigure our Cluster environement because we are having issue getting...

Got it to work. Just got confused w/ the DTS properties. Your was a 'DTSStep_DTSActiveScriptTask_2' and my next step was a 'DTSStep_DTSExecuteSQLTask_2.' thanks for the help..

I created what you described also. But when I executed the ActiveX Script, I get either a

Object required: 'stpDataPump'

or the Step 'Next' is not found.

Here's the code:

Set pkg=DTSGlobalVariables.Parent

Set...

I'm somewhat confused. I tried several way of approaching what is described here but I can't get to do what I wanted. I created an ActiveX to count the...