So I'm writing a VB program that reads/writes an Oracle database. I'm given the database name, username, password, and table names. So far so good. I connect up, see the tables I need to see, read ...

There's a problem with schemas in SQL2K5 that I encountered again this week, and I put my head to it and developed a very elegant solution that I thought I'd share with everyone. Problem: When you ...