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

arpitgupta02
Level 1
MS SQL stored Procedure working fine in SQL notebook but not in SQL recipe

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.

0 Kudos
0 Replies