I'm pretty sure I remember reading that client tools (EM and QA) must be reinstalled on all clients for SP4.  I don't remember the issues, but this might be one...

You do not have to restart SQL after ALTER DATABASE.

Have you looked at replication or log shipping?  Unless a large percentage of the production database has been modified from one...

You might think "there should be no problem with what to join together" because you put parentheses around the derived table, but the query optimizer has its own agenda sometimes. ...

After some experimentation I found that

grant

VIEW DEFINITION on SCHEMA::dbo to ddladmin_user

The use of the old-style syntax promoted the entire WHERE clause to the ON clause.  You get the same results as the "wrong" query if you used "LEFT JOIN ......

Integers will perform better than decimal because a CPU can't do arithmetic on decimal values.  They have to be converted to a scaled integer representation to be used in expressions,...

Was this database (or an ancestor) ever replicated?  A database that was set up for replication would exibit the same symptoms (log not truncating) if the replication agents were stopped but the...

You'll have better luck in general with linefeed (CHAR(10)) than carriage return (CHAR(13)). 

As pointed out already, CONVERT(CHAR(1), 0x0A) is just a long-winded way of saying CHAR(10).

If you only needed a one-time fix, then you're in good shape.

If you have to move databases between servers more often, say between test and production, it helps if you...

You might try examining the log for clues with undocumented DBCC commands:

DBCC

LOG ( '<database>' |

I double-checked in BOL just to make sure I was correct.  A CHECKPOINT in simple recovery mode truncates the logical log file (marks virtual log segments as reusable) but doesn't...

Simple recovery mode does not cause the tran log file to shrink.  You could set the autoshrink option for the database to make that happen (not a best practice in...

That is correct, you just need to make sure the logins are recreated with the correct SID in the master database.  Roles and permissions for the users will be restored with...

The EXECUTE AS statement has a syntax error and does not execute, so the context is never changed to Bob.

The correct answer is D, but it may not be the...

Don't use the "sp_" prefix on user stored procedures, especially when giving advice to newbies.  It might be years before he realizes what a cruel joke you've played on him.