Comments
Sort by recent activity
Thanks for the reply. Firstly, I am on the latest version, and i can also say that your script does not reproduce the issue. I did try playing with the SP to try to replicate one of the SPs in my database, but was unable to get the error to reproduce. I.m not quite sure where to go here. My database is rather complex, as are many of the stored procs, so I cannot script enough of it out to enable a reproduction. All I can say is that after running the invalid objects scan, several Stored Procs are listed with this error, and the only thing that they seem to have in common is the OPTION ( RECOMPILE ). All other SPs are listed as fine, and all with this option get this error. It may very well be a combination of things.
I have attached a screen shot of the dialog. I have also attached a script of the stored proc listed first. I realise that this will not allow you to duplicate the issue, but I don't seem to be able to duplicate it myself. If anything jumps out at you as an issue (for SQL Prompt, not in coding style) please let me know.
[image]
/ comments
Thanks for the reply.Firstly, I am on the latest version, and i can also say that your script does not reproduce the issue. I did try playing with the SP to try to replicate one of the SPs in my d...