Oh my gosh, thank you. It seemed so simple. Here I was trying to debug one problem and I created a new problem for myself.

Thank you so much.

Warm regards,

Hope

What was left out were all the declares and the declare for the cursor. I have shown it below. I took a working procedure that works fine against the development...

Thank you Brian this is just the amount of direction/confirmation I needed!

I will do exactly as you suggest - create a (permanent) log table in my database with some stored...

Continuing...

Found the 'inserted' table and now know a little bit about it and the 'deleted' table. I also found in the msdb database 'sysjobhistory', 'sysjobs', 'sysjobsteps' and many other potentially...

Continuing...

I found the following in the 'Scripts' section of this forum. Can anyone tell me where the table 'inserted' is? Thank you.

Hope

>>>>>>>Found this in the 'Scripts' section<<<<<<<<<

create trigger trg_stepfailures

on sysjobhistory

for...

continuing...

The line with the BREAK in it does not need a 'then'

The openquery() doesn't take variables. Possibly I can EXEC another sproc that will create a temporary linked server as...

Hi Matt,

Below is the concept I have, but still not yet working. But I have hope. No, that's not right, I am Hope. Thanks for today.

Warm regards,

Hope

CREATE PROCEDURE sync_pr_wmast...

Matt, before I can finish reading all that relates to your reply I want to thank you. Thank you. Your comments about T-SQL and dynamic SQL shed more light on...

Continuing...

Things work. When I executed the CREATE PROC from Query Analyser everything was fine.

Still working...

When the stored procedure syntax check as good but I get the error

Error 7405: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection....

Continuing,

While waiting for comments some simple things done already:

1. created a SQL Server Agent Job with steps that executes when required

2. step one in the job is drop table...