Well the thread title is very fitting then.  You are in way over your head.  Probabely much more than you can imagine.  You need an experienced DBA on this project. ...

How about this : Here I have a job that is run every day.  This job writes a batch file that move files around.  Maybe you could do something similar...

I don't see why this would be a problem.  This site alone sends over 500 000 e-mails / day (ok the table is often purged but still).  And it's nothing...

You'll have to plan some down time while doing the final transfer.  Once you get it working at resonnable speed, plan the required downtime and make the transfer.  But this...

Have you looked at the code of the system proc to see if it could be adapted to 2000?

I just rememeber one post where Joe Celko flamed someone for using that term, and now I can see it is more spread than I first imagined.  Now I can...

I think you'll have to do some pooling at a specific interval.  And run a query like :

Select top 1 null FROM LinkSrver.master.dbo.SysObjects

This is what EM manager runs under the hood.  That should get you stared :

BEGIN TRANSACTION           

  DECLARE @JobID BINARY(16) 

  DECLARE @ReturnCode INT   

  SELECT @ReturnCode = 0    ...

Why change that setting when you don't have too???

Since when do we need to use replace on parameters when not using dynamic sql?

And how would the param be set in the first place?

You first save the dml statement using dbcc input buffer.  Then you can enter that statement into it's own history table, save the id of the record and then use...

Have you tried inversing the tables?

Does this return any rows?

SELECT PolicyNumber, COUNT(*) AS Total FROM #temp GROUP BY PolicyNumber HAVING COUNT(*) > 1

SELECT PolicyNumber FROM #temp tmp LEFT OUTER JOIN dbo.GE_ReservesFile GE ON tmp.PolicyNumber = GE.PolicyNumber WHERE GE.PolicyNumber IS NULL

It's like saying I should never have a car accident, I should not be a victime of identity theft. 

There's only one way to be safe, be assured that you...

More on this here :

http://www.sommarskog.se/dynamic_sql.html

http://www.sommarskog.se/dyn-search.html

http://www.sommarskog.se/arrays-in-sql.html