--**************************************
--
-- for :Spaces Used
--**************************************
--
Copyright : Jerome MAZET (France)
jerome.mazet@usa.net
code: Can't Copy and Paste this? Click here for a copy-and-paste friendly version of this code!
Terms of Agreement:
By using this code, you agree to the following terms...
1) You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
--**************************************
--
-- Name: Spaces Used
-- Description:Space Used : This script
-- gives you all the space used by each tab
-- le
-- By: Jerome MAZET
--
-- Returns:Space used by data, indexes,
-- space allocated, and free space for each
-- table
--
--This code is copyrighted and has-- limited warranties.Please see http://
-- www.Planet-Source-Code.com/xq/ASP/txtCod
-- eId.311/lngWId.5/qx/vb/scripts/ShowCode.
-- htm--for details.--**************************************
--
/*********************************************************************/
/* PROCEDURE stockee: SpaceUsed */
/* Creation Date:20/06/2001 */
/* Copyright:Jerome MAZET*/
/* Written by:Jerome MAZET */
/* Contact: jerome.mazet@usa.net*/
/* Web Site: http://devinfo.multimania.com*/
/* Principe: Cette PROCEDURE retourne la place utilisee par chaque*/
/*table*/
/**/
/*********************************************************************/
DECLARE @tablename sysname
DECLARE tables_cursor CURSOR
FOR
SELECT name FROM sysobjects WHERE type = 'U' ORDER BY name
OPEN tables_cursor
FETCH NEXT FROM tables_cursor INTO @tablename
WHILE (@@FETCH_STATUS <> -1)
BEGIN
EXEC ('sp_spaceused ' + @tablename)
FETCH NEXT FROM tables_cursor INTO @tablename
END
CLOSE tables_cursor
DEALLOCATE tables_cursor
