User Tables with Size  all DBs (SQL 2005 Only)

Hope this is helpful to someone.  This script will create a table and a stored procedure in the master database to gather and store table info for all datbases. The sp uses a temp table to hold the results returned by sp_spaceused, then transfers the information to the permanent table DatabaseTableSizes and adds the database […]

5 (1)

2007-07-16 (first published: )

273 reads

Blogs

Everyone Run a SQL Saturday in 2021

By

With SQL Saturdays being rebooted, and the SQLSaturday.com website live, it’s time for events....

Modern Data Warehouse & Reverse ETL

By

An extension to the Modern Data Warehouse (MDW) that I have heard a bit...

Daily Coping 12 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

How to check latency for user database.

By sizal0234

Hi, One of the user databases was in Not synchronizing / In recovery mode....

How to map out multi-level Supervisor/Employee relationship

By YSLGuru

No doubt this has already been answered and probably detailed many ways so I...

T logs increasing

By atulyan.aries

Hi In one of our servers the t-logs of one of the database which...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers