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 |
![]() |
try use yourdb go sp_helpsegment logsegment go "Rodrigo C. Nery" <rodrigo@zaffari.com.b> 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 |
![]() |