How to setup a script to automatically monitor log files

Is there any way to setup a script that can monitor sql
server 2000 log files automatically by using something
like dbcc sqlperf (logspace) go.
Any help will be appreacited.
Thanks,
Aboki.Look at performance condition alerts in BOL. You can define an alert on =a percentage full level on whichever log file you want, then take some =action, like backup log when it happens.
Mike John
"Aboki" <waco361@.hotmail.com> wrote in message =news:01df01c34d68$c7984ad0$a501280a@.phx.gbl...
> > Is there any way to setup a script that can monitor sql > server 2000 log files automatically by using something > like dbcc sqlperf (logspace) go.
> > Any help will be appreacited.
> > Thanks,
> Aboki.sql

How to set up row/column labels for matrix report?

It seems the row/column lables are not automatically created in the matrix
report as in table report.
Anyone know how to do this?
Thanks,The matrix automatically creates the labels based on the x-axis (columns)
fields that you supply it.
-Tim
"yongli" <yongli@.discussions.microsoft.com> wrote in message
news:3BF751AA-4752-41B0-B1EE-5A6247B9C6B4@.microsoft.com...
> It seems the row/column lables are not automatically created in the matrix
> report as in table report.
> Anyone know how to do this?
> Thanks,|||Thanks for the quick response. Probably I didn't provide the full details.
When I used the report model base on my OLAP cube, the labels were created
automatically. I was talking about creating a free-form report using matrix,
when I draged the dataset (based on MDX) field over to the column/row in the
matrix, it didn't create lable for me, so I wonder if I have to manually add
it in the case.
Thanks,
"Tim Dot NoSpam" wrote:
> The matrix automatically creates the labels based on the x-axis (columns)
> fields that you supply it.
> -Tim
> "yongli" <yongli@.discussions.microsoft.com> wrote in message
> news:3BF751AA-4752-41B0-B1EE-5A6247B9C6B4@.microsoft.com...
> > It seems the row/column lables are not automatically created in the matrix
> > report as in table report.
> >
> > Anyone know how to do this?
> >
> > Thanks,
>
>|||Gotcha. If you use the report wizard first to see how the wizard sets up
the matrix, this might help. I usually use the matrix wizard to create the
report, mainly because I'm lazy...
T-im
"yongli" <yongli@.discussions.microsoft.com> wrote in message
news:19CACC04-476B-47A1-9962-3A90A724B7A4@.microsoft.com...
> Thanks for the quick response. Probably I didn't provide the full
> details.
> When I used the report model base on my OLAP cube, the labels were created
> automatically. I was talking about creating a free-form report using
> matrix,
> when I draged the dataset (based on MDX) field over to the column/row in
> the
> matrix, it didn't create lable for me, so I wonder if I have to manually
> add
> it in the case.
> Thanks,
> "Tim Dot NoSpam" wrote:
>> The matrix automatically creates the labels based on the x-axis (columns)
>> fields that you supply it.
>> -Tim
>> "yongli" <yongli@.discussions.microsoft.com> wrote in message
>> news:3BF751AA-4752-41B0-B1EE-5A6247B9C6B4@.microsoft.com...
>> > It seems the row/column lables are not automatically created in the
>> > matrix
>> > report as in table report.
>> >
>> > Anyone know how to do this?
>> >
>> > Thanks,
>>