Forcibly terminate all user processes as step 1 of your scheduled task - here's a stored proc that I got from somewhere that does this, for a named db:

SET QUOTED_IDENTIFIER...

As you are not relying on the 'inserted' table in any way, is there any reason why you don't just create a view over the dbo.assay_sample table?

create view vwUDEF_PIMA as

SELECT...

You may like to keep the new tables in a completely separate database to allay management concerns relating to upgrades of the JDE databases. This would seem to be...

First thing: do you really need

select * ...

or can you just select the fields you need?

Next thing to do is replace the subquery with a join and replace the...

I've got an idea that I've read somewhere that EM returns the results of such a query in 'batch' mode - allowing you to see subsets of results as they...

So why not create a table in Oracle that contains UPC codes from SQL Server? This should do away with all that text file business.

Part 1: ensure that the...

Ken, I'm not sure that I can picture the sequence of events you are considering. Are you saying that you would analyse the existing SQL Server data and then...

Hmmm - tough one. Is there some way that you can start maintaining a "Transfer to SQL Server?" flag against the Oracle data. You will know from the...

Rather than using straight DTS, have you thought about adding the Oracle server as a 'linked server' and using straight T-SQL to accomplish the data transfer?

What is the relationship between tables a and b - is it on event?

So, in English terms, table a is an 'Account Events' table and table b is an 'Event...

"Also you may want to consider an extra field on the row to say completed."

Expanding on Eric's idea, why not create an extra calculated field on the table = number...

Try unregistering the DLL, type:

regsvr32 '[enter full dll file path and name]' /u

from a DOS prompt and then reboot and try deleting it again.

Phil

I use a Cisco VPN connection over the internet fairly frequently and have no problems with EM/QA over that (except that it trashes my local network connections).

Phil

Yuk. I'm assuming that you have tried (or perhaps you do not want to try!) performing a SELECT of all the fields into local variables and then checking them...

This sounds a bit suspect to me. Can you provide a bit more detail about what you are going to do with the number? If I was filling...