title: In C#,using select SCOPE_IDENTITY() causes deadlock?
body: <p>By replacing <code>@@identity</code> with <code>SCOPE_IDENTITY()</code> I am getting a deadlock, though using <code>scope_identity()</code> is recommended by Microsoft.</p>
  
  <p>In my C# method, I have lot of insert queries for master and it's details. Does anyone know why calling <code>scope_identity()</code> would cause timeout or deadlock issues?</p>