space

Hello to all.

I need to know one way to check only the utilized space log areas from one
database. The command sp_helpdb returns the information separated by devices,
but I need to obtain the information from the all log devices in one line,
including total and occupied space.

Example:


     DATABASE NAME              TOTAL LOG SPACE           OCCUPIED LOG SPACE
     example_database           100 MB                    80 MB

Is there someone can help me?  Are There something miracle store procedure?

Thanks.

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp

0 Rodrigo 9/10/2001 4:23:35 PM

try

use yourdb
go
sp_helpsegment logsegment
go


"Rodrigo C. Nery"  wrote in message
news:1FwrwThOBHA.277@forums.sybase.com...
> Hello to all.
>
> I need to know one way to check only the utilized space log areas from one
> database. The command sp_helpdb returns the information separated by
devices,
> but I need to obtain the information from the all log devices in one line,
> including total and occupied space.
>
> Example:
>
>
>      DATABASE NAME              TOTAL LOG SPACE           OCCUPIED LOG
SPACE
>      example_database           100 MB                    80 MB
>
> Is there someone can help me?  Are There something miracle store
procedure?
>
> Thanks.
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp

0 PB 9/10/2001 4:04:46 PM