title: How do I easily find IDENTITY columns in danger of overflowing?
body: <p>My database is getting old, and one of my biggest <code>INT IDENTITY</code> columns has a value around 1.3 billion. This will overflow around 2.1 billion. I plan on increasing it's size, but I don't want to do it too soon because of the number of records in the database. I may replace my database hardware before I increase the column size, which could offset any performance problems this could cause. I also want to keep an eye on all the other columns in my databases that are more than 50% full. It's a lot of tables, and checking each one manually is not practical.</p>
  
  <p>This is how I am getting the value now (I know the value returned may be slightly out of date, but it's good enough for my purposes):</p>
  
  <pre><code>PRINT IDENT_CURRENT('MyDatabase.dbo.MyTable')
  </code></pre>
  
  <p>Can I use the <code>INFORMATION_SCHEMA</code> to get this information?</p>