Elmah and SQL Server Compatability Mode 90

Question

The script to setup up the SQL Server database for Elmah has a warning message that says the database is designed to work under SQL Server Compatability Mode 80 (SQL Server 2000). Does anyone know if there are any problems in running the script to build the database on a Compatability Mode 90 database.

Answer 1

There are no known issues with running the script on a 90 (2005) or 100 (2008) server, so you can remove that line out of the script if you want. It's just because it hasn't been 100% formally tested

We use it in a SQL 2005 server at the moment, but are upgrading to 2008 shortly

Answer 2

I have been using Elmah with Sql Server 2008 R2 without any problems.