| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 368.1 | See SQLMAINT | FUSE::VELLETRI | | Tue Apr 29 1997 09:18 | 4 |
| See SQLMAINT for automated database maintenance.
> 2) Is it possible to automate the DBCC reports(?) or do I have to
> continue invoking them manually?
|
| 368.2 | first question too, please | ALFSS1::WALTERS | | Sat May 03 1997 12:39 | 4 |
| Thanks for reply to question 2.
Can someone help me with question 1?
Thanks,
craig
|
| 368.3 | | CSC32::HOEPNER | A closed mouth gathers no feet | Mon May 05 1997 18:23 | 4 |
|
Look at the available DBCC commands to look at space available. I
can't remember off hand which ones to use.
|
| 368.4 | sp_spaceused | AMCUCS::BETTS | | Tue May 06 1997 15:48 | 21 |
| If you are looking for space used by your database try this:
use DatabaseName
go
sp_spaceused
go
If you've had major changes to your database size, you and force
sp_spaceused to recalculate. Caution: on large databases this
can take some time.
sp_spaceused @updateusage = 'TRUE'
go
Hope this helps,
/Eric
|
| 368.5 | | GUIDUK::HEALY | Alan Healy @ZSO | Tue May 13 1997 14:51 | 9 |
| to report the amount of space used in a table used sp_spaceused
<tablename>, e.g., for the log:
sp_spaceused syslogs
name rows reserved data index_size unused
-------------------- ----------- ------------------ ------------------------------------ ------------------
syslogs 3137 240 KB 232 KB 0 KB 8 KB
|