For some reason I had to do the change twice in order for the system to save the change from a period to a dash. Once again thanks for your...

I changed the procedure to the following: exec sproc.Infmtx_003_MonthlyAR. I now get the error Error could not find the stored procedure 'sproc.Infmtx_003_MonthlyAR' [SQLSTATE 42000] [Error 2812].

A thousand apologies. I have not had a chance to fix it yet. I am fixing it today using the previous posting from last month. I am processing right now.

After thinking about the issue I decided to go with a regular insert instead of a bulk insert and everything worked out great.

INSERT INTO dbo.dic_Client_RoleAssign(clid,roleid,usrid)

...

I realized this error only happens to me when I am using the VPN network from home to connect to the remote session to the server I need to get...

Thanks for your patience. I thought I had copied and pasted to avoid errors but I was wrong. The command needs to be exec dbo.sproc_Infmtx_003_MonthlyAR with an underscore after sproc...

When I look at the job step properties under the general tab

StepName: MonthlyAR,

Type is Transact SQL,

Database is ARC_Rpts,

Command is exec dbo.sproc.Infmtx_003_MonthlyAR.

Job step properties under under the advanced tab...

I have added the screen shot of the step itself in case I made a mistake.

I have attached the screen shots of the failure. If I run this procedure individually I don't get an error, so you comment makes sense. I am not sure how...

This is the code in step 3

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[sproc_Infmtx_003_MonthlyAR]

AS

--- Added 4 Drop table code to avoid duplication 9/11/2013 TD

IF OBJECT_ID('tmp_ARDetail') is not null

BEGIN

DROP TABLE tmp_ARDetail;

END

IF OBJECT_ID('tmp_AR')...