"JohnM" <Jo***@discussions.microsoft.com> wrote in message
news:2DDDF0E4-BCCB-4C65-A31F-A352526DF48E@microsoft.com...
> In SQL 2000, it was easy to view the details for a database and
> transaction
> log by changing the view of the database in the SQL Enterprise Manager.
> With the new Microsft SQL Server Management Studio for SQL 2005, I cannot
> find the location to monitor the size of the database, size of the
> transaction log, and how full the transaction log is.
> Can someone please point me to the location in Microsft SQL Server
> Management Studio in order to do this?
>
> Thanks,
> John

"Bill Ramos [MSFT]" wrote:

> Hi John,
>     SSMS has a canned report that can give you the information you are
> looking for.
> 1. Press F7 to call up the Summary Page
> 2. Navigate to the database in Object Explorer that you are interested in
> 3. Select the Report command in the Summary page and choose the Disk Usage
> report
> Please note, this only works against SQL Server 2005 server instances and
> the compatibility level for your database must be set to 90.
> --
> Cheers,
> Bill Ramos, Lead PM, SQL Server Manageability
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> "JohnM" <Jo***@discussions.microsoft.com> wrote in message
> news:2DDDF0E4-BCCB-4C65-A31F-A352526DF48E@microsoft.com...
> > In SQL 2000, it was easy to view the details for a database and
> > transaction
> > log by changing the view of the database in the SQL Enterprise Manager.
> > With the new Microsft SQL Server Management Studio for SQL 2005, I cannot
> > find the location to monitor the size of the database, size of the
> > transaction log, and how full the transaction log is.
> > Can someone please point me to the location in Microsft SQL Server
> > Management Studio in order to do this?
> >
> > Thanks,
> > John
>
>
>

"JohnM" <Jo***@discussions.microsoft.com> wrote in message
news:A61192A4-98F7-4E66-8EA0-677CDB6C3C75@microsoft.com...
> Hi Bill,
> That makes lots of sense.
> One more question: how do you change the compatability level for the
> database?
> We are at a level of 80.
> Thanks,
> John
>
> "Bill Ramos [MSFT]" wrote:
>
>> Hi John,
>>     SSMS has a canned report that can give you the information you are
>> looking for.
>> 1. Press F7 to call up the Summary Page
>> 2. Navigate to the database in Object Explorer that you are interested in
>> 3. Select the Report command in the Summary page and choose the Disk
>> Usage
>> report
>> Please note, this only works against SQL Server 2005 server instances and
>> the compatibility level for your database must be set to 90.
>> --
>> Cheers,
>> Bill Ramos, Lead PM, SQL Server Manageability
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights
>>
>> "JohnM" <Jo***@discussions.microsoft.com> wrote in message
>> news:2DDDF0E4-BCCB-4C65-A31F-A352526DF48E@microsoft.com...
>> > In SQL 2000, it was easy to view the details for a database and
>> > transaction
>> > log by changing the view of the database in the SQL Enterprise Manager.
>> > With the new Microsft SQL Server Management Studio for SQL 2005, I
>> > cannot
>> > find the location to monitor the size of the database, size of the
>> > transaction log, and how full the transaction log is.
>> > Can someone please point me to the location in Microsft SQL Server
>> > Management Studio in order to do this?
>> >
>> > Thanks,
>> > John
>>
>>
>>