Forum Discussion
Stored Proc is running , is there anyway to see what database it is working on
Stored Proc is running , is there anyway to see what database it is working on? the script is Ola Helgren's IndexOptimization on all user databases. I tried using sql profiler but nothing usefull ca...
No, you can only see the name of the procedure, but not which line of is currently running, nor the cross-database access.
You have to implement a logging in your code.
You have to implement a logging in your code.