Thanks. I was hoping to avoid either choices 🙂

I was looking for the ability to answer multiple choices. This will teach me to answer the QOD while people are calling and asking me questions. I didn't...

Agreed, I've worked w/ both PL/SQL and T-SQL and am fluent in both. If this is a one time deal you may be lucky and find little change in...

Are you talking about migrating the source code for the stored proc, like CREATE OR REPLACE PROCEDURE shema.objectname

Or are you suggesting the return of a result set from a stored...

How are you logging into Oracle in the DTS package? Does the table exist under the schema, is a synonym needed, or does the schema account of permissions...

Thanks for the input everyone. I was hoping DTS could push it to an Exception file. The reason I was and am trying to avoid a temp staging...

Thanks Michael. I thought about that approach and am still hoping for something different.

...Jeff

Balance Tree? What the heck is that? I know what a B-tree is and a B* tree, but....

....biting my toungue!!

Good rule of thumb..

Tuning is all about I/O

What is a datatype of BYTE? Did you mean a BIT datatype, or something like a CHAR(1)?

I disagree with having indexes on all tables and can create a situation...

If you have an IBM UDB database let me know and I will change my response.

Set up a job to FTP the tables from DP2 to a staging area (maybe...

Not that I am aware of. The shrinking of the database as far as I know, reduces the size of the files in the database. I am not...

mhenriks,

On the surface it sounds like a good idea. And like others have posted, hardware, risk assessment, maintenance, etc., are all issues you must think about. With...

I agree w/ Steve.

Try setting something up through NT to check the service. Maybe through the command line and NET START w/ an e-mail program like BLAT, or using...

Figured I would touch base since this topic had a lot of volume.

I changed the priority boost, and set working set size options to 0 (zero) and we have not...