Thanks for awarding me the point! It was an interesting question. Thanks again!

Interesting topic, I just googled shard and that concept now has my head spinning. I am going to create a sample azure database to learn more about it.

Thanks!

I agree. Trick Question.

This was the fix for me. Thanks!

C:\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\

Why does this lock the entire table when only one of the rows is locked in a transaction? I thought the first two inserts were implicit transactions - so they...