1

Using SSMS with linked servers. Have stored procedure in Express version that performs a table insert. When the stored procedure is run locally, the table insert works.

When I run an Agent Job executing the stored procedure from the linked Enterprise version, the table insert does not happen. Linked servers are set up properly - I have all permissions turned on for both target table and stored procedures.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Joe T
  • 11
  • 1
  • Is there anything visible in the [SQL Server Agent Error Log](https://learn.microsoft.com/en-us/sql/ssms/agent/sql-server-agent-error-log?view=sql-server-2017)? – TT. Aug 24 '18 at 16:56
  • Nope. Everything acts/reports like it ran perfectly - but the insert doesn't happen when run from the job. – Joe T Aug 24 '18 at 17:03
  • Any difference when running the SP from the remote server, but directly from SSMS rather than from an agent job? – TT. Aug 24 '18 at 18:37
  • I have tried exec via SSMS query window on remote server and get the same result (no insert on target table). It seems to be a property of the Express version. I have another location that is Enterprise-to-Enterprise version and have no problem. – Joe T Aug 24 '18 at 18:42
  • Can you read [this question](https://stackoverflow.com/q/32477446/243373) and the answers to that question, to see if that sheds any light on your issue? – TT. Aug 24 '18 at 18:48

0 Answers0