Wow... that's pretty rude... I just found your other 10 cross posts that you posted every 30 to 60 minutes.

This is a cross post...

http://www.sqlservercentral.com/Forums/Topic445746-145-1.aspx#bm446281

Those symptoms seem to match the symptoms in the KB article that VYas mentioned. Did you read the article?

We need to know what the current service pack...

Ok... thanks for the feedback, Lester.

Ok, thanks for the info. I'll see what I can do tonight after work.

Would you share your solution, please?

James,

Are you expecting the TestID to repeat, starting at 1, for each HeaderID in the test table?

Just add the column as a nullable column. Then populate it. When you're done, alter the column to be not null.

Bulk Insert can see the files on the user desktops if the server is logged into the domain with the correct privs.

...If anyone knows, please post it here so we can all learn something...

It was a real life coach... I think Karthik can go a long way if he changes his...

Thanks for the feedback... as always, my test data may not be 100% the same as your situation... once you've tried the index, lemme know how it works... might be...

There is... assuming that your serial numbers are actually integers...

SELECT GapStart = (SELECT ISNULL(MAX(b.SerialNumber),0)+1

...

Heh... make sure you get rid of that pesky TempDB database while your at it. 😛 All it does is take up room and cause headaches... saves a lot...

Just a passing thought... maybe even a...