If the create view works on one database, but not the other, I would first check to make sure that user iv\markw has been added onto the current db.

Another argument for separate databases for separate applications, is in the off-chance you need to restore data from one, you're not obligated to restore data from all (or worrying about...

There's no easy way to do this, that I'm aware of, so it someone has a way, I'd love to hear it. I'm guessing a lot of people would take...

Visual Basic allows for the use of resource files, to make localization of labels very straight-forward (and so you don't have to hard code it).

If the VB program is linked...

Can you post the query you're using, or a reasonable facsimile? It's difficult to come up with suggestions just based on the results as listed.

We use Red-Gate's SQL compare and SQL data compare tools (http://www.red-gate.com) for all of our moves from development servers to production servers.

They offer a 14-day fully functional demo...