At Tech Ed 2008 I made a mental note when Paul Randal mentioned that you can't use Database Mirroring when you've got the Filestream feature turned on. I like Database Mirroring and so that was useful information.

In preparing a bunch of demos for SQL Server 2008, I'm using the AdventureWorks2008 database currently available on the Codeplex site. Installing this database requires the Filestream feature, so I turned it on.

Some of the demos I'm working on are existing demos written for the AdventureWorks database on SQL Server 2005, and I've found many of them don't work. It turns out that the structure of the database has been modified, eliminating some tables commonly used in demos (Person.Contact, for example), and changing the column names of primary keys as well as other columns.

I also discovered that you can't set the READ_COMMITTED_SNAPSHOT and the ALLOW_SNAPSHOT_ISOLATION options on if the Filestream feature is enabled, so to demo those options I'll have to load the old AdventureWorks database as well as the new AdventureWorks2008 database.

Fun!

Allen