We have a system that is in production that has a store procedure that actually is called by an ASP.net Solution and instead of calling the database, makes certain HTTP calls etc. We need an expert to edit the procedure so it logs the parameters and the calls that are been made to the store procedure so we know how to call it, from an external application that is not the original ASP.net solution. Because aparently the store procedure is not really hitting the database then we have no way of tracing it through SQL Server Profiler.
It must be an SQL Server expert because this will be done on the production environment because is the only environment we have to be able to trace what we need to trace. So the Goal is this: 1) Edit Store procedure so it logs everytime is called and it logs all the parameters he is been call it with.
So we can see exactly what is been called and how.
Clearly comment the changes to the store procedure so we can comment that code to disable it after we make the traces and we are able to uncomment the code again to be able to start again tracing when we deem that necesary. We need someone that know what he is doing because as we said this will be done directly on the production environment.
19 freelancers are bidding on average $33 for this job
I have experience in the area of logging stored procedures in case of unexpected transactions rollbacks from C# side. So my skills gives me possibility to resolve this task in a most effective way.
I am a sql developer and involved in writing complex tsql queries and stored procedures. Logging can be done by me in 2 days. 1 day for development and other for unit testing.