can anyone tell me the cmd or store procedure that gives
me the space of the database log
Hi,
DBCC SQLPERF ( LOGSPACE )
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"?" <anonymous@.discussions.microsoft.com> wrote in message
news:2bf201c4287d$fe1c5830$a601280a@.phx.gbl...
> can anyone tell me the cmd or store procedure that gives
> me the space of the database log

can anyone tell me the cmd or store procedure that gives
me the space of the database logHi,
DBCC SQLPERF ( LOGSPACE )
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"'" <anonymous@.discussions.microsoft.com> wrote in message
news:2bf201c4287d$fe1c5830$a601280a@.phx.gbl...
> can anyone tell me the cmd or store procedure that gives
> me the space of the database log

can anyone tell me the cmd or store procedure that gives
me the space of the database logsp_helpdb dbname
will give you the sizes of the mdf and ldf file.
>--Original Message--
>can anyone tell me the cmd or store procedure that gives
>me the space of the database log
>.
>|||Hi,
DBCC SQLPERF ( LOGSPACE )
--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"'" <anonymous@.discussions.microsoft.com> wrote in message
news:2bf201c4287d$fe1c5830$a601280a@.phx.gbl...
> can anyone tell me the cmd or store procedure that gives
> me the space of the database log