Would it help if you made the ID column in the "one" table your primary key, then create an index on ID + Date columns and specify Unique values?

From a previous reply:

*****************************************

The DISABLE/ENABLE trigger looks like the tidiest one to implement since so many stored procs touch the table in question and only 1 app needs to get...

"But, as I stated above, any other SPs running concurrently with the SP that disables the trigger will also not have the trigger in effect."

Great point Jonathan...that kills that fix.

...

Thanks all, great stuff!

We're running SQL7 so we don't have the CONTEXT_INFO variable.

The DISABLE/ENABLE trigger looks like the tidiest one to implement since so many stored procs touch the table...

We may add a column to the table and then test within the trigger code the value in that column as to whether we continue processing the code or drop...

That's what I thought.

Thank you.

Thanks all.

That is excellent...Thanks.

Thanks Frank,

You got me thinking....

So I scripted all the tables in the db including triggers and am searching the table name in QA.

Regards,

Randy

Thanks Shas3,

This is a reporting db and I have additional backups on the VAX/Alpha platform. My mission-critical dbs use separate drives to store the data, the logs, and the backups....

Yes, jaybmehta's post is correct. In SQL7 EM, click the database's properties and on the options tab, check the truncate log on checkpoint box.

I advise that you make sure...

YOU GOTTA BE SH*TTIN' ME!!!

(sorry I hit enter too soon - YGBSM)

I had never heard SQL pronounced sequel until I started using MS SQL Server, so the first reply to this topice seems correct to me.

As for all the acroyms...YGBSM!

I neglected to mention that this is a report-only db and the weekly load job has not occurred yet. Additionally, the 2 major tables contain 14 indexes.

Here is something to try with your DTS pkg. Open the package in design mode, right-click your connection and look at the properties. Click the advanced button and you should...