MS SQL stored Procedure working fine in SQL notebook but not in SQL recipe

Options
arpitgupta02
arpitgupta02 Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1 Partner

Hi,

I am trying to execute MS SQL stored procedure in DSS to create a dataset from connection, It works fine in SQL notebook but from there we cannot create a dataset in flow so I want to execute it as a SQL recipe but there my Stored procedure is giving error, Invalid object name.

Can somebody help what can be the issue as I am running same SQL stored procedure for running at both places.

Setup Info
    Tags
      Help me…