Add @@servername in the query. It will give the server name in the output results.

Yes. Application server is on VM.

this work worked like a charm. This is the one I am looking for. Thanks a lot.

select istatus, dtmoveout, bmovedout, *

from tenant

where istatus in (1,4)

and dtmoveout + 7 < getdate ()

and isnull(bmovedout,0) <> -1

Try like this.

SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query],

deqs.total_elapsed_time/1000000 as Total_Execution_time,

deqs.total_worker_time/1000000 as CPU_time

FROM sys.dm_exec_query_stats AS deqs

CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest

ORDER BY deqs.last_execution_time DESC

Have you checked what it is trying to delete? If the command is deleting millions of rows, and you are trying to kill, then it is trying to roll...

Try this link.

http://social.msdn.microsoft.com/Forums/is/sqlsetupandupgrade/thread/9f88d038-e485-4446-a788-5caaa7eadd5b

Got the solution.

yes

Thanks, wayne.

Nevermind. I figured it out

I have service table

Dealerid Vin transactiondt

123 xxxx sep 30 2010

123 ...

Thanks guys. it is working. is there any to automate so that every time new row added it will update by itself

I applied the latest patch of iseries ODBC and it isworking fine. Thanks for all of your help

Prema

I ran it from. They do not have PK on any servers