Edit Store procedure to log values and execution (MS SQL Server 2008R2)
$10-30 USD
Pago na entrega
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.
ID do Projeto: #16483041
Sobre o projeto
17 freelancers estão ofertando em média $33 nesse trabalho
RE: Edit Store procedure to log values and execution (MS SQL Server 2008R2) Hi there, I understand from your project description that you intend to modify a stored procedure in such a way that it will create a log Mais
I can get logging activity done for you. Will need to discuss one or two points then it should not take more that one hour... Thanks, Muhammad Ali Safder
Hi: I've been working with SQL Server since version 7, and I am a ASP.Net and .Net programmer. That's the platform I use every day for my Projects. I have more that 20 years of experience. So, I know how ca Mais
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.
Hello, I would love to work on this project. I am working on MS Sql Server stack for last 5 years and my total experience is more than 7 years I have worked on similar projects before, and know how the things Mais
Hi, I have 10+ years of experience in vb.net, asp.net, sql server development. I am interested in your project. Relevant Skills and Experience If possible send me details like stored procedure script and how it is cal Mais
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.
