Not sp_delete_job and sp_delete_jobschedule, presumably? Is it that you want the final part of your job to be self-deletion?

Phil

Sorry for asking the bloody obvious, but has tempdb been deleted? As you cannot start the SQL Server service, check in Windows Explorer for existence of C:\Program Files\Microsoft SQL...

Yes - Print does an implicit conversion to char or varchar if it can.

Phil

I think it is the cast to varchar where you are losing data. Try using the STR() function:

DECLARE @a as float(53)

DECLARE @DynSQL1 varchar(1000), @DynSQL2 varchar(1000)

SELECT @a = 367970.45

SELECT @DynSQL1...

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...