Technical Article

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: )

274 reads

Blogs

Daily Coping 19 Aug 2022

By

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

Daily Coping 18 Aug 2022

By

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

New parameter in sp_DBPermissions and sp_SrvPermissions: @CopyTo

By

I’ve added a new parameter to my permissions scripts (well, just the main two...

Read the latest Blogs

Forums

The Case for Patching

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Case for Patching

Is it possible to purge Extended Events file (target) contents?

By VoldemarG

Is it possible to purge the Extended Events file's (target) contents WITHOUT deleting the...

Flow Control Problem with multiple statements

By Paul Stasny

I am creating a function that should retrieve a numerical value from notes. This...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers