If i add domain\sqlman as remote login it gies below error:

Executed as user: DOMAIN\SQLMan. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [SQLSTATE 28000] (Error 18456). The step failed.

and...

Dude please tel how to do it

i have domain\sqlman account with admin rights on srvr1

but if i use it as remote login in linked server then...

try thi out

------------------------------------------------

Declare @intEquipID int

Declare @strMaintDescription varchar(50)

Declare @intRecurr int

Declare @i int

Declare @intFrequency int

Declare @dteMaintStartDate datetime

Declare @MaintFlag numeric(18,0)

Select @intEquipID = (Select EquipID From Inserted)

Select @MaintFlag = (Select MaintFlag From Inserted)

Select...

try this out

---------------------------------------

Declare @intEquipID int

Declare @strMaintDescription varchar(50)

Declare @intRecurr int

Declare @i int

Declare @intFrequency int

Declare @dteMaintStartDate datetime

Declare @MaintFlag numeric(18,0)

Select @intEquipID = (Select EquipID From Inserted)

Select @MaintFlag = (Select MaintFlag From Inserted)

Select...

thanks...........:):):):) .vry mich .myjob started finally after vigorous efforts of 3 working days...thnx once again:).

Earlier "Be made using logins current security context" was enabled

But i enabled 4th option where...

procedure :

------------------------

CREATE Proc [dbo].[ap_mtn_Sync_Table_data]

@EndDate DATETIME,

@prefix VARCHAR(100) ...

thanks ......but it didnt work

the job contains following code:

---------------------------------------------------

EXECUTE AS LOGIN = 'domain\sqlman'

GO

DECLARE @EndDate DATETIME

SET @EndDate = GetDate()

EXEC dbo.ap_mtn_Sync_Table_data @EndDate, 'LU_'

------------------------

with above code it gives below error...

hi Markus Bohse,

Can u please send me note for MCDBA paper .i m desperate to give exam...but i m not getting notes..

Pleaseeeeeeeeeeeeeee..help mee

Already Enabled

thanks for your suggestion but it is already enabled.....any oher IDEA?

it was pleasure to give you solution...well where do you work ,,are you working as DBA ......

i am working as DBA ...in india

hi

I will elaborate more about the problem.

first server has sql agent login : DOMAIN\sqlman (sysadmin)

AND second server has its sql agent login : DOMAIN\sqlman (sysadmin)

More over both...

hi i execute your sp in my server first of all it gave syntax error and moreover it didnt throw any error either on Master or anu user database

---------corrected...

hey,

actually i have 2 servers.

i want to schedule a job on server A which will excute a query on linked server (server B)

i m using sql login :...

Actually no...can you tell me procedure to check it ?