Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: dbcc shrinkfile time estimate

    SELECT T.text,
       R.Status,
       R.Command,
       DatabaseName = DB_NAME(R.database_id),
       R.cpu_time,
       R.total_elapsed_time,
       R.percent_complete
    FROM sys.dm_exec_requests R
       CROSS APPLY sys.dm_exec_sql_text(R.sql_handle) T

Viewing post 1 (of 1 total)