It is not throwing an error while creating the SP, since only on execution it start parsing the inner text (query/SP/dynamic query...) and then it raise the error. The same happened on dynamic query for example. The reason it is "hidden" during the create SP statement, is that it use external resource which the server do not check on "create SP": "INSERT INTO #TMP (ID_2) EXEC dbo.Sample_Procedure_1"
This has nothing to do with using SP in SP (nested SP) and I can re-create the issue in one SP if you want to see :-)
* Please close the thread, this is the way the server behaves. If you have any idea of improving or changing the indesign behavior than you can open a CONNECT :-)
[Personal Site] [Blog] [Facebook]
No comments:
Post a Comment