[dba-SQLServer] NEVERMIND (Fw: executing systemstored procedure)

the general syntax that I use is:
--Lifted from the web...

CREATE TABLE #tblTableData
 (
  vchTableName VARCHAR(100) NOT NULL,
  intRows INT NOT NULL,
  vchReservedSpace VARCHAR(100) NOT NULL,
  vchData VARCHAR(100) NOT NULL,
  vchIndexSize VARCHAR(100) NOT NULL,
  vchUnusedSpace VARCHAR(100) NOT NULL
 ; )
INSERT INTO #tblTableData
EXEC sp_MSforeachtable 'sp_spaceused ''?'''

SELECT * FROM #tblTableData

DROP TABLE #tblTableData



-Francisco
http://sqlthis.blogspot.com | Tsql and More...


On Wed, Jan 14, 2009 at 3:17 PM, Susan Harkins <ssharkins at gmail.com> wrote:

> Not really, but I didn't work on it today at all. I'll try again tomorrow
> and see what happens.
>
> Susan H.
>
>
> > Susan,
> >  Did you ever get this resolved?
> >
> > -Francisco
> > http://sqlthis.blogspot.com | Tsql and More...
> >
> >
> > On Tue, Jan 13, 2009 at 1:23 PM, Susan Harkins <ssharkins at gmail.com>
> > wrote:
> >
> >> Don't worry about it Martin -- it's my problem -- I'm sure I'm just
> >> expecting the wrong thing.
> >>
> >> Susan H.
> >>
> >>
> >> > Susan
> >> >
> >> > Sorry I am in the middle of AR on the new book. If you need this
> >> > working
> >> I
> >> > can check it in the morning in work on another server with Adventure
> >> works
> >> > installed. Can spend a while on it then.
> >> >
> >> > Martin
> >> >
> >> >
> >> > Martin WP Reid
> >> > Information Services
> >> > Queen's University
> >> > Riddel Hall
> >> > 185 Stranmillis Road
> >> > Belfast
> >> > BT9 5EE
> >> > Tel : 02890974465
> >> > Email : mwp.reid at qub.ac.uk
> >> > __________________________
>