Not sure there's an easy way to do this in 65. Been a long time. I know modifying system tables worked easier in 65 and you might be able to...

Will add it to the list and see. The server is in the US on Mountain time, BTW.

select a.*

 from table1 a

   right outer join table2 b

      on ....

where a.xx is null (pick some column)

Is this SQL Server 7? The sort order and code page are different on the restore server. You set these when you install the server.

dbcc checkidentity will allow you to reset the seed for the identity column.

I like your method. It's simple, fast, almost bulletproof. Other methods will be more complex and have more places for things to go wrong.

The biggest issue is to be sure...

I'd do this in two steps in DTS. First import this into a table that just moves the data. Easier this way.

Then setup a stored procedure that selects the top...

http://www.sqlservercentral.com/columnists/sjones/pushftp.asp

Are you saying EM is slower than QA?

Does 8 seconds really matter? I'm sure you'd like an answer, but I don't have one. At times EM is slower or faster...

I knew someone that tried it, seemed to work. Chris Hedgate wrote an article (http://www.sqlservercentral.com/columnists/chedgate/sqlandjavagoonadate.asp) on it. I'd email him and see.

Still in Yukon Beta 1 BOL so I'd guess yes.

How do you use this?

Don't use it here, but the MS Operations team uses it extensively for the MS.com site. If this is an issue, I'd bet that custom scripting is used to get...

LIKE

create table MyTest1

( myid int

, mttxt text

)

go

create table MyTest2

( myid int

, mttxt text

)

go

insert mytest1 select 1, 'This is a test'

insert mytest1 select 2, 'This is a test2'

insert mytest2 select 1,...

Yes

Noted. We'll get to it.