Thursday, September 28, 2006

SQL Server Reports

I wrote a SQL query the other day to determine how many rows there were in each table in my database. I now realise this information is available directly using a Management Studio Report. From SQL Server Management Studio, select the database you would like to work with from the Object Explorer. From the Database Summary page click the report button in the toolbar. There are several reports available from this drop down button but Disk Usage Report is the one we want. Then expand the Disk Space Used by Tables section and hey presto, there are the record counts and plenty more besides !

No comments: