Matt - thank you.

I will check this out shortly.

Pretty sure I checked thoroughly and it looks clean. The last column did contain data with commas, and the delimiter was a comma. I requested they send a data file...

Using Import/Export Wizard. This is a test database. Taking it straight to the table. I did drop and recreate the table. Same thing. I can try creating a staging table.

Sorry, my previous post was in response to LightVader's post.

I use MS OneNote for just this. Keeping virtual notebooks on all the different areas of responsibility. Each 'notebook' having sections, etc. Extremely handy.

Had the same situation on one of our SQL Server 2000 servers today, where the Service Control Manager was restarting the SQL Server service. The clue was in the Event...

It appears to be the results only.

Thanks everyone for the replies and suggestions. It helps to be able to bounce ideas to arrive at a solution.

Kevin

If I run the query from SSMS on my laptop, it builds the tmp file locally. So SSMS is using this tmp file to build the result set. So we've...

C:\Documents and Settings\ \Local Settings\Temp\tmp25.tmp. I'm assuming with each new query it creates a new tmp file, since it was tmpB.tmp on the prior select.

I'm sure it's something as simple...

They are set to Full. I'm not doing tlog backups using the MP Wizard, but this was a good thing to double-check anyhow.

I applied KB934458, but that did not resolve...