I don't see the subscriber.

What job category is it? REPL-Distribution?

The error is in the job history of the SQL Server Agent job that is the Distribution Agent (named <distributor_name>-<publication_name>-<subscriber_name>).

Possibly it will tell you the distributor cannot connect to the...

What is the error in the previous job step history message?

That would work as well.

I normally do not take that approach for two reasons.

1. I try to avoid changing the database objects if can.

Especially if it...

That would work

If 200 RawVehicle record have 400 child records in one of the other tables,

you will delete all 200 RawVehicle, but only 200 of the 400 child records.

Does RawVehicle have a one to one relationship to the other tables?

If if it is one to many, you will leave orphans in the other tables.

One way to do this...

Search for the column name in syscomments

If you run:

EXEC xp_logininfo 'DOMAIN\GROUP_NAME', 'ALL'

You will get all AD groups under which they have access to the server

You either use modify procedure instead of create,

or you do drop procedure and then create procedure with the new code.

If this is unclear look up modify procedure in BOL.

You are mis-specifying @maxRow

Should be:

SELECT @maxRow = count(*)

FROM master.sys.databases d

WHERE d.database_id not in (1, 2, 3, 4) and d.state_desc = 'ONLINE'

Thanks Vedran and Gail for pointing out that a primary key is not the equivalent of a clustered index.

Where does this confusion come from?

You only need to specify instance name OR port number, not both.

Can you ping the SQL server box from the remote server?

Can you telnet to the servername,port from the remote...

We had this issue on old backup processes due to system backups.

The simple fix was to back up to a file name with a date and timestamp.

In addition to job owner, the "run as" of a step may be associated with an invalid SID.