Home Forums SQL Server 7,2000 Administration dbcc shrinkfile time estimate RE: dbcc shrinkfile time estimate
raymel_vb
Grasshopper
Points: 15
More actions
September 7, 2017 at 2:27 am
#1958510
SELECT T.text, R.Status, R.Command, DatabaseName = DB_NAME(R.database_id), R.cpu_time, R.total_elapsed_time, R.percent_completeFROM sys.dm_exec_requests R CROSS APPLY sys.dm_exec_sql_text(R.sql_handle) T