title: SQL Server 2008 sys.objects equivalent to sysobjects.uid
body: <p>Does anyone know how to get an equivalent of the SQL Server 2000 <code>sysobjects</code> <code>uid</code> column from the 2005+ <code>sys.objects</code> (or another) view?  </p>
  
  <p>I am trying to convert this code, as we are getting rid of all <code>sysobjects</code> references.</p>
  
  <pre><code>DECLARE GETOBJECTS CURSOR FOR 
  SELECT NAME, UID FROM SYSOBJECTS
  WHERE TYPE IN ('U','P')
      AND UID &lt;&gt; 1
      AND LOWER(RTRIM(NAME)) NOT LIKE 'PB%'
  </code></pre>
  
  <p>Thanks in advance,</p>
  
  <p>Kevin</p>