Regarding the "central/shared" database: We have scripts that do the nightly build process, and do a database install to a shared server, with the extra twist that the build...

David Portas (3/23/2010)

"Associative Entity" is semantic modelling terminology and not a relational database...

The basic idea for this topic is useful to brand-new database designeres - build a new table when there is a many-to-many relationship between two other tables. But note...

In the SQL 2005 world, I've wondered (but not implemented) code using the SQLCMD metacommand :setvar and :r.  One could use these like #define and #include in C++.

File1.sql

#setvar enumMale M

#setvar...

Doh!  Found another place in my own upgrade script that was altering it back to an int.  Works every time - make a post and then find your mistake.

I'm sort of surprised you didn't go one step further and make the MessageFrom, To, and Subject be IDs out to a separate table.  There has got to be a...

Also answered D - assumed it was a trick question.  Please review better.