CuteDesiGal Posted April 27, 2020 Report Share Posted April 27, 2020 Remote access disabled so direct ga linkedserver thru run cheyalenu. sp ayithe ila declare chesi running successfully but job ela chestham. declare @runstoredprocsql varchar(1000); set @runstoredprocsql = ‘exec dbname.dbo.sp’; exec (@runstoredprocsql) at “remote server”; print ‘proc executed’ Quote Link to comment Share on other sites More sharing options...
CuteDesiGal Posted April 27, 2020 Author Report Share Posted April 27, 2020 Ltt Quote Link to comment Share on other sites More sharing options...
Gentle_Boy Posted April 27, 2020 Report Share Posted April 27, 2020 Were you able to add that remote server in your sql management studio...by any chance ? And then access it ? Quote Link to comment Share on other sites More sharing options...
CuteDesiGal Posted April 27, 2020 Author Report Share Posted April 27, 2020 Yes i can but server a nunchi server b loni job kickoff cheyali Quote Link to comment Share on other sites More sharing options...
Gentle_Boy Posted April 27, 2020 Report Share Posted April 27, 2020 2 minutes ago, CuteDesiGal said: Yes i can but server a nunchi server b loni job kickoff cheyali U can do that...keep trying .. Google it Quote Link to comment Share on other sites More sharing options...
CuteDesiGal Posted April 27, 2020 Author Report Share Posted April 27, 2020 Got it thanks Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.