>Hi
>I am facing problem that, INSERT is blocked by SELECT statement. The scenario is as below
>
>I have a processing that will retrieve, process and insert record to SQL Server table for each employee; I have a report that will SELECT records from same table with INNER JOIN with additional table as well.
>
>User reported that, when ever he run the process at machineA, and another user run the report at machineB, the INSERT will fail in process. If user kill the SQL server process that is running the report SQL statement, then the process INSERT will back to normal.
>The report SELECT statement consist of MAX() and GROUP BY, but it is not apply to the table to be inserted anyway.
>
>Any ideas?
>
>Thank you
What are transaction isolation levels used by each of the scenario?
See this summary
http://aboutsqlserver.com/2011/09/28/locking-in-microsoft-sql-server-table-of-content/ and you can read each of these articles.
If it's not broken, fix it until it is.
My Blog