there can be tons of reasons why it gets stuck

- how is your linked server defined

- problems with the network ?

- is the...

Rowversion is a sysnonym for timestamp datatype.

This timestamp-column is (automaticaly) altered every time the row is updated.

What can it do ? Just indicate if the row has been changed since...

maybe http://www.sqldts.com has the answer.

Is this job origination from another server ? (check the "target server(s)" pane when you edit the job)

You could try to alter the job so it only runs local, or...

If you have sqk2k, script the dts-package as visual basic and then search for the DTSStep_DTSExecuteSQLTask_3.

This way you may find your way using the gui to repair/intervene the issue....

search this site for "reporting service" and you'll find enough to start with

my 2ct (not knowing the exact buisiness rrule)

select  case when day(getdate()) > 14 then

   DATEADD(d, -1, DATEADD(m, 1 + DATEDIFF(m, 0, getdate()), 0))

else

  convert(datetime,cast(year(getdate()) as char(4)) + '-' + cast(month(dateadd(m,1,getdate())) as char(2))...

"server=localhot;uid=sa;pwd=;database=Northwind" 

I guess you want to connect local.

Try server=.

or server=localhoSt

btw : even on dev/test server it is not wize to have sa-password...

- first check out who or what is blocking and consuming.

( maybe http://www.sqlservercentral.com/scripts/contributions/111.asp can help)

- Is it just a job or was it a maintenance plan you've deleted ?

First : start you sp with set nocount on (unless you realy need the rows info)

Why aren't you using a transaction ?

- view-triggers only fire when the view is being used !

- you could place triggers on the underlying objects