I'm sorry to say that I am not surprised at your solution. More and more I find work-arounds resorting to Access. Not an optimal solution when in an...

I see that it has been over a month since your post and see no replies to this. Have you had any success in this area? I ask...

SQL Server 2005 does not recognize a carriage return/line feed anymore for delimited text files.

Only the delimited text files...fixed width functions is not affected.

I can send the trouble ticket info later...

Basically (by default in SQL Server), a primary key with a clustered index will ALWAYS keep the data for that column in ascending order.  If a record is inserted, the...