i think a good summary. for the second one i can add something. Imagine that you have 200 databases but they have different characteristics so you have to classify them....

i think a good summary. for the second one i can add something. Imagine that you have 200 databases but they have different characteristics so you have to classify them....

sorry i couldn't explain well.

I have only one step for the job. "DTS run" step .....

the 2 steps are in my DTS package. When i run the DTS it...

First im sorry job is working on SQL Server 2000.

Actually im running a DTS package between 2 servers(i call them A and B). DTS has 2 steps. First...

Hi r.dragoi,

It worked. Thanks really much for your help.

Hi, Finally i found something not so complicated as a solution :

if exists(SELECT st.text, r.session_id, r.status, r.command, r.cpu_time, r.total_elapsed_time

FROM sys.dm_exec_requests r

CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS st where...

Hi Lenny,

Thanks very much for your reply. I think i can use this method for sps and functions as you said. And i will create a job which will...