The table will be created, but if an attempt to insert or update a row resulting in a row that is greater in size than can fit on a page...

You make good points and I apologize for my late response.

One point you miss is that you can easily do dynamic searches via stored procs by selecting the...

I would test their knowledge of how transactions work within SQL Server. A good example is what happens when you have stored proc with a transaction with three inserts...