title: MVC ELMAH and SQL Azure
body: <p>back-story:
  We mainly use AWS for everything (hosting, database, notifications, etc.). Now, I'm looking at moving the database side to SQL Azure since we've been getting crazy bills on AWS RDS. So all I tried to do was create a DB in SQL Azure and update the connection string to point to the new DB. In the past, ELMAH (this specific implementation: <a href="https://github.com/alexanderbeletsky/elmah.mvc">https://github.com/alexanderbeletsky/elmah.mvc</a>) worked flawlessly in the past.</p>
  
  <p>current situation:
  I just created a new DB in SQL Azure and noticed key differences right away namely on not supporting:</p>
  
  <p>ON [PRIMARY], NONCLUSTERED KEYS, etc.</p>
  
  <p>I migrated my db fine (for now), but when I applied the updated scripts for ELMAH to the db and tried to go into the tool, I get errors!</p>
  
  <p><strong>I'm somehow convinced that it's a db problem</strong>, because if I remove: 
  <code>&lt;errorLog type="Elmah.SqlErrorLog, Elmah" connectionStringName="DefaultConnection"/&gt;</code>  which basically defaults ELMAH to store everything locally, I get to access ELMAH.</p>
  
  <p>Anybody got ELMAH to work on SQL Azure? Could you give me the SQL script to generate the tables and stored procedures?</p>