More info on the May 2009 update to SQL Server 2008 Books Online
I finally got around to installing this update today, and thought I would mention a few things.
- Don't be surprised that "Books Online (May 2009)" actually says "April 2009" in the application's title bar and on any page which states the version. (I already received one private message asking me why they got the April version instead of the May version.) This has happened for every Books Online update that I can remember — it just takes time to publish and distribute; I don't know what else to tell you.
- To make item 1. even more confusing, the "New and Updated Topics" topic is actually dated "March 30, 2009." Again, please don't nit-pick. While I am quite happy to use the easier-to-update web interface for most things, I am also happy that they are dedicated to pushing these releases out to us, even if it does take 45 days to actually go from "done" to "installed." (Now where is the mobile version for my iPhone?)
- There is a new example in the topic "CREATE USER" that shows how to create and use a user without a login. I had no idea you could create a user without a login behind it. If it weren't for this update (and the fact that they have committed to documenting changes in a sensible way – just check the "Change History" section at the bottom of any page), I would never have been looking at this topic.
- The sp_configure option 'user instance timeout' has been added to the list of deprecated instance options. Initially I thought this had to do with SQL Server Express Edition's user instances option, but apparently this specifically involves just the Compact Edition.