[Thursday, August 12, 2010]

Here's a handy little script that we keep in the "useful scripts" folder at work. I used it earlier today to do a quick check if certain tables were being filled with data.

select o.name, rows
from sysobjects o inner join sysindexes i on o.id = i.id
where i.indid < 2 and xtype='u' and o.name not in ('dtproperties')
order by o.name

Much easier than writing select count(*) from tbl for every table I'm interested in.

Posted by: Benjamin Felt

Search

Recent Posts

  1. SQL Job History
  2. Check for existence of temp table
  3. Merge - Conditionally Insert, Update, or Delete
  4. Copy Table
  5. Deleting Duplicates
  6. Deactivate Autorecovery
  7. MS SQL "Stuff" Keyword
  8. MS SQL Cursor
  9. MS SQL Row Count