title: Sql Server sysprocesses query
body: <p>I have the following query which runs fine on all of my sql server 2005/2008 databases </p>
  
  <pre><code>SELECT sysprocesses.spid
  FROM master.dbo.sysprocesses
  </code></pre>
  
  <p>However for one of my databases it give me a binding error on the spid column (cannot bind multipart identifier).</p>
  
  <p>I've check the compatibility mode of the db and it's set to 2005 so I'm sure this isn't the problem but can't figure out what else to check.</p>