I'm working in both SQL 2000 and 2005, so although I did double post, the situation applies to each system.

It is a clever solution to the design bug. Probably like many other readers, I'm trying to think of the underlying problem.

My 3rd thought was to see if all the...

The scenario is this. A textfile, with column headings in the first row, cannot find a corresponding table name. If the table does not exist, I would like the process...

That's a good idea, and could be a very clever/simple way (my favorite combination) of accomplishing this.

Could something similar be used for dynamic table creation?

The file name is identical to the table name. So table EntRptATM.txt maps to EntRptATM table.

I would like my son's mother to stop messing him up so much. I'd like to spend more time with him, but then that's his wish as well. Maybe we...

You've read my mind in terms of what I was looking for. Pointed out the rabbit trails and the reasons for the final result was a nice touch, too.

My situation...