True, and IF the Author has a very small set of previous articles, and/or IF the previous article had a similar name...

I was fortunate in that the Author only had...

This was a 'bad' question. Choice E could never be correct as long as Choice D was above it in the presentation!

There are two (2) things to enable. The job and the job schedule. Have you checked to determine if BOTH are being enabled?

 I meant to write:

Something like:

SELECT (dateadd(s,1,getdate()))

Something like:

SELECT (datepart(s,1,getdate())

Often, when dropping a table and recreating, or vice versa, is not a good idea. The table may have a complex security (permissions) scheme, and when dropped, all permissions are...

True, however, if done is a window of no activity, hopefully, there are NO open transactions, and the log would be truncated and flushed rather quickly. I do this quite often and...

If this could occur during a window when there is no other activity, I would consider switching into 'Simple' (non-logged) mode, delete, the switch back into logged mode. Depending upon...

Again, the timestamp datatype has NOTHING to do with time. It is a serialized value that changes every time there is a change to any column in the row -and also...

I would shorten the BETWEEN expression to:

    DATEADD(hh,-1,GETDATE()) AND GETDATE()

But most importantly, what is the datatype of the column [timestamp]. If it is a 'timestamp' datatype, you will never get...

One option would be to deny their net logins access to the database (or server) -hopefully your network is using groups to contain the various users. Then create an application role...

or, if you want to make it a scheduled job, create a script file and use osql