Thats what I figured, seems obvious enough.

Is this what Frank K. was refering to in an earlier, unrelated post?

Are their any tricks I need to know to make this work...

Pakya is right on the mark. All you need is MSSQL2K DTS. (Data Transformation Services). No 3rd party required.

If you have a dump (export) of an Oracle database...

I'm trying to think of a funny "alter acronym" for BOL but just cant think of one right now.

Posts...I just enjoy reading all the good stuff here. I feel...

I've had a similar issue, but didnt resolve it. I'd like to see what the causes of this could be. My solution was to rewrite the package and...

Yes the problem is EXCEL. One possible workaround it to have the first row with no leading zeros, sort of a header row.

xxxxxx,xxxxxx,xxxxxx,xxxxxx

001234,012345,000123,000012

quote:

---

quote:

---

Yes.

You can also create an aggregate column(s) in a table. This is good...

Yes.

You can also create an aggregate column(s) in a table. This is good for reporting purposes as theres no need to do the calculations when the report is running.

...

DTS export to text and specify delimiter as ;.

What other States require this kind of auditing?

Yes, Using Uniqueidentifer is the "key" to making this work. You could copy the database to a new instance and rename it to Archive*. Create a DTS package...

Edwin is correct. You need the "insert into log" statement to be in a different transaction for it to committ regardless of a rollback for the remaining inserts.

...

You say in QA... You mean when you run @@version is doesnt show 8.00.760 as the version of MSSQL2K?

You can check for the change date of SYSPROCESSES table in...

Are you connecting through EM?

Hey Brian,

Your on 8.00.818?

What's that?

I thought the latest was 8.00.760? (SP3)

Is that SP3a?

Isaiah

Edited by - iadams on 12/05/2003 10:09:32 AM

What about the fragmentation in this table your truncating? If it is very fragmented will the delete take longer? I think it would. If you have a...