Thanks Rishi,
I am just executing a Stored procedure say, sp_proc1.
But in the sp_proc1, I am using two different servers, say serv1, serv2.
Stored procedure resides in the serv1.
So, I have used a query like this,
SELECT * INTO mytablename FROM serv2.mydb.dbo.mytablename...
HI all,
I have a stored procedure, It runs well as a stored procedure. But When I made it as a Job It fails. What may be the reason? I have come across a error diagnosis message 'NT Authority/ Anonymous logon'
Thanks,
Amjath
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.