Viewing 2 posts - 1 through 2 (of 2 total)
to track DB growth I use the following. (tdb is an archive table for reporting)
Create table #tDB
(dbName varchar (255),
dataSize float,
log_size float,
space_used float,
calc_date datetime)
go
--db size
sp_MSforeachdb "INSERT INTO #tDB SELECT...
May 6, 2004 at 8:57 am
#505492
thanks lowell,
this looks like it will help for the image files but i am still troubled by a description field (text datatype).
we are migrating our backend web database to...
January 14, 2004 at 7:27 am
#489949