View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 07:14 PM
S G
 
Posts: n/a
Default Useful Stored Procedure Question


Hi all,
I did a search for a stored procedure that would give me the table
sizes and space used for each table within a database and found this in
the archives ‘exec sp_MSforeachtable 'exec sp_spaceused ''?'''
The sp_spaceused I found in the help but where is the
sp_Msforeachtable? How does this work and yes I’m new to this.
The stored procedure is perfect for my needs I just wouldn’t mind
knowing how it works!
Many thanks
Sam



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply With Quote