title: SQL Server 2008: I have 1000 tables, I need to know which tables have data
body: <p>Is there a way in SMSS to detect whether a table has any records? I need to get a list of tables that have records. perhaps there is a sql statement that will do the trick?</p>