Thanks for the responses... as stated I already have a "fix", the intent was as a "heads up".

I don't think adding a sys table/view with such basic names should be...

True. When you use one of the multitude of ways to check the existence of a table such as your "select * from routes" sql.

However:

"I inherited some VB code that...

unless there is a different way to cast the path, you need to use a simpler path.

You said it is in "ProgramFiles", but this folder generally has a space "Program...

Our small (25 staff) company was acquired last year by a sizeable corporation. We had programmers (employees not contractors) that were allowed to work "virtual" from home and come into...

Does it make sense to anyone why this isn't a built-in option within SQL (MSAccess, SQL 2000, SQL 2005, PL/SQL)? Seems to me that a DateDiff formatted option (hh:mm:ss, mm/dd/yy)...

Sorry, I did receive the email but discounted it as an advertisement and for IT support. I'm not on the network staff, so I have not had a need to...

Great comments, must mean it was a really good article.

A lot of our managers want comments/revision notes so it leaves a kind of DNA trail...developers DON'T want it for the...

"Avoid framing block comments. It looks attractive initially but is difficult to maintain..."

Not nearly as difficult as trying to maintain code without revision notes of who did what so you...