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.

Try

D:\readpga>c:\mssql7\binn\isql -Sclarcombe -dpga -Usa -P -w256 -h-1 -Q"exec AGGT_INRUNNING '''SCORE'''" -oaggtscoreir.htm

This is some crazy error that we havne't been able to track. Seems about 2 in 10 here with IE 6 as well. With Mozilla (1.5) I don't get the...

I see this periodically and usually change all jobs to be owned by "sa" to avoid this. It's got to be some type of domain authentication issue, but it's so...

No. If the AD group has a login , then the user will have access (unless they are denied).