title: Sql server management studio reporting "The semaphore timeout period has expired."
body: <p>On our development sql server, executing any query containing more than approximately 700 characters stalls for about 10 seconds and then reports the following error:</p>
  
  <blockquote>
    <p>Msg 121, Level 20, State 0, Line 0<br>
    A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)</p>
  </blockquote>
  
  <p>for example, this query</p>
  
  <blockquote>
    <p>select * from FooTable where id = ' (.. and then 700 spaces ..) '</p>
  </blockquote>
  
  <p>fails fails with the timeout error while this one</p>
  
  <blockquote>
    <p>select * from FooTable where id = ' (.. and then 600 spaces ..) '</p>
  </blockquote>
  
  <p>fails with the expected <em>Msg 8169, Level 16, State 2, Line 1
  Conversion failed when converting from a character string to uniqueidentifier.</em> - immediately.</p>
  
  <p>Indeed, throwing <em>any query, including random garbage</em> at our dev sql server exhibits this behaviour, while any other sql server I have available acts as expected, so I would think that the query never actually gets to parsing on the server.</p>
  
  <p>I'm at a loss here - any hints?</p>