What did you do?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Even if the allocation units of the drive have some slack left over it seems odd that you would need that much extra space to do a restore based on...

Check out the following thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=2903&FORUM_ID=8&CAT_ID=1&Topic_Title=Get%20the%20value%20of%20an%20autoincrement%20identity%20col&Forum_Title=T-SQL Andy makes mention of Scope_Identity() function for SQL 2000 as a better option and other ideas are given.

"Don't roll your eyes at me. I...

I beleive that the performance monitor counters have objects for each instance so you can look at them individually.

"Don't roll your eyes at me. I will tape them in place."...

Can you post the example as we have had a few threads here about Joe Celko and I am afraid I have never seen his examples.

"Don't roll your eyes at...

I agree with Andy in that I see no reason why you would want to do this as you lose the advantage of stored execution plans unless you are making...

Although I don't suggest doing it for the sake of data consistancy you could try using.

ALTER TABLE tblX NOCHECK CONSTRAINT all

ALTER TABLE tblX DISABLE TRIGGER all

then do your truncate...

When you say TEMP table how are you generating it. If thru a stored proc make sure you have SET NOCOUNT ON at the begining after the as and do...

If you still get failures I would start a trace in Profiler to see if the link is even reachin gthe box and what may be failing.

"Don't roll your eyes...

Please do not crosspost, see response at http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4114&FORUM_ID=19&CAT_ID=3&Topic_Title=BULK+INSERT+WITH+IDENTITY+COLUMN&Forum_Title=Data+Transformation+Services+%28DTS%29.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

There is no switch to utilize a column in BULK INSERT to not overwrite the column. Only KEEPIDENTYT which allows you to insert an Identity value from the file. DTS...

See related thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4109&FORUM_ID=65&CAT_ID=1&Topic_Title=Case+Study%3A++Expansion+plan+of+450+GB+database&Forum_Title=Performance+Tuning for my post.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Ok there are a few things to consider.

How often do the DC's do there thing (i saw the other post)? Once a month, daily, etc.

How often are writes...

Have you made any recetn changes to structures on the 7 box? Found a metadata issue with 2000 linking to 7 and it could be related to this. Also how...

That is what I was afraid of. Then your next best option would be with a temp table, which should work best if you limit to the data you need...