Hi Brian,

In trying to run the MSforEachTrigger script in 2005 I'm getting errors - any idea what's going on??

Thanks, Simon

Msg 16950, Level 16, State 2, Procedure sp_MSforeach_worker, Line 27

The variable '@local_cursor' does not currently have a cursor allocated to it.

Msg 16950, Level 16, State 2, Procedure sp_MSforeach_worker, Line 32

The variable '@local_cursor' does not currently have a cursor allocated to it.

Msg 16950, Level 16, State 2, Procedure sp_MSforeach_worker, Line 153

The variable '@local_cursor' does not currently have a cursor allocated to it.

Msg 16916, Level 16, State 1, Procedure sp_MSforeach_worker, Line 155

A cursor with the name 'hCForEachDatabase' does not exist.