Found my reason: The SSMS shortcut on my desktop was a 32 bit version. When I ran the 64 bit version it worked. Why I had a 32 bit version...

Ditto.

Just a quick poll(ish) question. [No pun intended.]

True or False: If the SQL Server service is the only thing running (dedicated server), the default max memory setting of (bignum) is...

Huh. You're right, it was about SP2, not R2. My bad. Still, I didn't expect it so it was really frustrating when I tried to move one and it didn't...

If you've got a mixed shop with 2008 and R2 remember that once the database gets onto R2 it's heck getting it back onto a 2008 database.

My company had one app's SQL 2005 database on one server that needed to look up stuff in another app's SQL 2000 database on another server. We did the linked...