In my first times I used to NOLOCK hint but it reads uncommited transactions and it is problem when you want to take stock amount or sales amount but...

Sorryy query is here....

SELECT wait_duration_ms,sys.dm_os_waiting_tasks.session_id,

sys.dm_os_waiting_tasks.wait_type,STATUS,

(select text from sys.dm_exec_sql_text(sql_handle))

FROM sys.dm_os_waiting_tasks

INNER JOIN sys.dm_exec_requests ON sys.dm_os_waiting_tasks.session_id=sys.dm_exec_requests.session_id

where STATUS <> 'background'

ESAT ERKEÇ

not DBA not MVP

Hi;

I think run this query and look at the your sql statment wait type if wait type start LCK it means lock if another think post...

I think you can create a temp table and insert the proc dataset in this table and then you can export this table.

Esat Erkeç