Sample Header Ad - 728x90

Easy way to get DB Measurements?

3 votes
1 answer
68 views
My senior management would like to have some counts of database objects (databases, tables, rows, stored procedures, etc) to show complexity to the executive committee. Does anyone know of a quick way to get this information? I'm going after system tables to get the info and some use of sp_MSforeachdb, but I'm hoping maybe someone has a query stored somewhere they can share. Of course it's needed by tomorrow and it's already 3:43 pm. We're using Microsoft SQL Server 2008 R2. And if anyone has ever been in this boat before, is there anything else your management wanted to see? TIA
Asked by Kellyleia (31 rep)
May 10, 2017, 07:43 PM
Last activity: Aug 12, 2017, 02:45 AM