I thought that the Drop table would let you write the excel from the top not from where the last cell it has which seems very much like the latter...

Also, I realize when the DTS Package runs (without doing the template copying over),

Example, if 150 rows should be the output on excel file, the 1st time it runs,...

I tried your way which sounds very good.

I still got a problem, when the dts package runs, the excel file remains empty (except for the column header) even though the...

Andy, thanks for promising that you'll find a solution to the updated (changed) rows.

I test it and it worked. This time instead of 18000 records recorded as changed, it...

I'm trying to reduce the Transaction backup size. The 1st Transaction Log Backup after the full Backup which is after the Reindexing job is huge.

This maybe...

I did what you say : Run a Full Backup afterwards and then run a transactionlog backup.

That transactionlog backup is still very big.

What about turning the database to simple mode...

Hi Andy,

This incremental Load is easy to understand because you made it very friendly to comprehend. Thanks for that part!!

However, the return results for CHANGED ROWS says 18460 rows....

I think you posted on the wrong forum. This is for SQL 2000 and SQL 7.0.

Thank you. And I think y ou are right about that. I've tested it similarly to your suggestion and now the storeprocedure plan is in par with the...

I dont' think that still works because when doing that under securables, you only have is: alter, control, delete, insert, references, select, take ownership...

Nothing about Drop permissions.

Thanks for suggestions. I would definetely pass those information to the network team to let them look at the clustering configurations. I also have used the sql profiler...

It is Active- Passive. Do you have any idea why I 'm getting that type of error message. And on top of that, the steps on the jobs...

Go to Query Analyzer and point to the Database:

Then type this:

sp_helprotect 'null', username

That will tell what type of rights the user have.

Hi,

The operating system files are on a different letter drive. It is not SAn-attached.

Don't know anything about RAids neither does the net guys.

It is read-intensive. The master and...

You're right. Thanks!