Progress from DBCC SHRINKFILE

Hello,
how can I see the progress of DBCC SHRINKFILE?If you are using SQL Server 2005, you may be able to get percent_complete
from sys.dm_exec_requests. This is often 0 for most operations, but it is
roughly accurate for some (including backup database). Not sure if it
covers DBCC.
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"Matze" <Matze@.discussions.microsoft.com> wrote in message
news:AF8ACF95-6C40-4C60-B9F0-42EA6B28661D@.microsoft.com...
> Hello,
> how can I see the progress of DBCC SHRINKFILE?
>|||Thank you Aaron,
for your reply.
"Aaron Bertrand [SQL Server MVP]" wrote:
> If you are using SQL Server 2005, you may be able to get percent_complete
> from sys.dm_exec_requests. This is often 0 for most operations, but it is
> roughly accurate for some (including backup database). Not sure if it
> covers DBCC.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
> "Matze" <Matze@.discussions.microsoft.com> wrote in message
> news:AF8ACF95-6C40-4C60-B9F0-42EA6B28661D@.microsoft.com...
> > Hello,
> >
> > how can I see the progress of DBCC SHRINKFILE?
> >
>
>|||Yes, it covers DBCC SHRINKFILE and DBCC SHRINKDATABASE in SQL 2005.
--
Paul Randal
Principal Lead Program Manager
Microsoft SQL Server Core Storage Engine,
http://blogs.msdn.com/sqlserverstorageengine/default.aspx
"Matze" <Matze@.discussions.microsoft.com> wrote in message
news:C3C5DA45-BE31-4E70-A2EA-82CA767FECA5@.microsoft.com...
> Thank you Aaron,
> for your reply.
> "Aaron Bertrand [SQL Server MVP]" wrote:
>> If you are using SQL Server 2005, you may be able to get percent_complete
>> from sys.dm_exec_requests. This is often 0 for most operations, but it
>> is
>> roughly accurate for some (including backup database). Not sure if it
>> covers DBCC.
>> --
>> Aaron Bertrand
>> SQL Server MVP
>> http://www.sqlblog.com/
>> http://www.aspfaq.com/5006
>>
>>
>> "Matze" <Matze@.discussions.microsoft.com> wrote in message
>> news:AF8ACF95-6C40-4C60-B9F0-42EA6B28661D@.microsoft.com...
>> > Hello,
>> >
>> > how can I see the progress of DBCC SHRINKFILE?
>> >
>>