|
|
Posted by Neil on 12/29/07 17:04
"Roy Harvey (SQL Server MVP)" <roy_harvey@snet.net> wrote in message
news:ijccn311ebhrnhi6jlq25tnf5gv3gq3v51@4ax.com...
> Since I see mention in an earlier part of the thread that you are
> running on SQL Server 7, here are a couple of system stored procedures
> I used in 7 to see how space was being used. Add them to the master
> database and you can use them from any database like other system
> procs. Note the double underscore in the names differentiates them
> from the system procs supplied by Microsoft.
>
> They are really just hacks of sp_spaceused. sp__spaceall shows all
> tables together, not one at a time. sp__spaceavail shows the total
> space but breaks it down into data and log, which is the only way it
> means anything.
>
> Before running them always execute DBCC UPDATEUSAGE(0).
>
Hi, Roy. Thanks for these! I installed them in Master, and sp__spaceall ran
fine. However sp__spaceavail gave the error:
Server: Msg 208, Level 16, State 1, Procedure sp__spaceavail, Line 18
Invalid object name 'master..sysusages'.
Thanks,
Neil
Navigation:
[Reply to this message]
|