Hey Jonathan,

Good article. A couple of minor things to mention, though. To detach the database you use "sp_detach_db" - not "sp_attach_db". It may also be worth noting that the physical_name...

Bill,

Many of the sysmessage strings contain placeholders that should be fed variables run-time. Extracting the string only will produce messages like this:

"Cannot insert the value NULL into column '%.*ls', table...

Hi,

I prefer to use static SQL in all cases where possible and only use dynamic SQL when there are a lot of where clause criteria to the stored proc. This...

Using the @map = false will drop references - not fix them. In my opinion answer 2 is correct (sp_changedbowner 'dbo').

/lasse

How could something like this possibly be worth 2 points? Beats me...

So the WriteText only allows for 120 kb interactively. Fine. This update is only 8400 bytes. So why are two statement necessary? In my view answer 3 is the correct...

Very interesting issue. I have no clue as to why SQL Server behaves like that, but I took the time to do the table defs and run the scripts. The...

That's the same in SQL Server 2000. The question is a bit tricky, though. Literally, the IDENTITY is reset to 1 using the DBCC CHECKIDENT (orders, RESEED, 1). Consequently, the next...

I for one would like to see my account credited for my correct answer. On my systems the events logged using xp_logevent show up in the Windows Application Event Log...