sp_spaceused (Transact-SQL)

Displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or SQL Server 2005 Service Broker queue in the current database, or displays the disk space reserved and used by the whole database.

Related posts:

  1. sp_change_users_login (Transact-SQL) Syntax sp_change_users_login [@Action =] 'action' [,[@UserNamePattern =] 'user'] [,[@LoginName =]...
  2. TOP 100 PERCENT and ORDER BY In SQL Server 2008, the TOP 100 PERCENT and ORDER...
  3. SQL Server Security: Database “db_datareader” Roles The db_datareader role The db_datareader role has the ability to...
  4. SQL SERVER – 2005 – List all the database List all the database on SQL Servers. SQL SERVER 2005...