I've got it working. I have added code before the insert that checks for ?'s and just deletes those rows and it runs fine. Thanks for everyone's help.

Thanks,

 I have found a problem in the file were there are characters like 'S' where a number is supposed to be. That causes this to fail.

It really all depends on how many concurrent connections and how the database is used.

 You may want to look into using sqlio to do a benchtest

I'll make sure I fully text it then. Thanks!

Cheers for that. It is a big help.

I don't need it in the database afterwards so that is fine.

I do have transaction log backups every 15 minutes. I thought about that but it's slightly more frequent. It could be a few of these jobs that are on this...

Fixed all the problems. The SQL cannot be the cause because the cache hit ratio in 99%+.

I need to find what it is that causes the large spikes in...

I've never seen it in the express Edition.

 I do have an Eval of SQL 2005 knocking about that I may try and install SSMS only. Hopefully that is possible.

Yeah, that's what I'm out to accomplish.

To be honest I'm not totally sure yet. I'm the SQL developer and we don't have anyone else. I got a book on ASP with C#. I have written some...

Thanks.

Would it be possible on the front end form for the date and tiem to appear as two field, even for updating?