I am getting below error when I recompile the SP get_data.
I am compiling the script which first drops the SP and recreates the SP. I am not able to find who is using this SP. I have closed all applications and quit the sql sessions.
Please note I would be only user using this SP. For workaround I am renaming the SP and creating again. But I am not able find the root cause.
Please someone let me know the solution.
Msg 3702, Level 16, State 1:
Server 'SYB_SRV1', Line 8:
Cannot drop the procedure 'get_data' because it is currently in use.