Cancelado

Edit Store procedure to log values and execution (MS SQL Server 2008R2)

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.

Habilidades: Microsoft SQL Server , SQL, SSIS (SQL Server Integration Services), T-SQL (Transact Structures Query Language)

Veja mais: store serial port receive data ms sql database, primavera ms sql server problems, online hotel booking sample project asp net ms sql server, online hotel booking asp net ms sql server code, mt4 ms sql server, jquery reading ms sql server database, joomla bridge ms sql server, java framework portal ms sql server, integrating metatrader client terminal ms sql server, hospital management system project ms sql server, execute perl script ms sql server, display results ms sql server java, configuring php ms sql server iis windows server, compare ibm db2 ms sql server, store form data sharepoint 2007 site sql server

Acerca do Empregador:
( 37 comentários ) Bogota, Colombia

ID do Projeto: #16483041

20 freelancers estão ofertando em média $33 para esse trabalho

codetod

Hi I am a database expert with 15 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. Mais

$30 USD em 1 dia
(49 Comentários)
5.8
AliSafder

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

$20 USD in 3 dias
(24 Comentários)
4.5
$25 USD em 1 dia
(32 Comentários)
4.7
alexpuche1970

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

$25 USD em 1 dia
(1 Comentário)
2.7
reedsystems

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

$25 USD in 3 dias
(3 Comentários)
2.1
$40 USD em 1 dia
(2 Comentários)
1.1
nitishgaur009

Hi, I have 5.3 years of software development exp. in - ASP.NET WEBFORMS, ASP.NET MVC, WCF, WEB SERVICES, AJAX, LINQ, TELERIK CONTROLS, [url removed, login to view], ENTITY FRAMEWORK, SQL SERVER, RADIS CACHE, SOAP, HTML-5, CSS-3, JAVASCR Mais

$25 USD em 1 dia
(0 Comentários)
0.0
$29 USD em 1 dia
(0 Comentários)
0.0
sudiptachoudhury

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

$25 USD in 2 dias
(0 Comentários)
0.0
raghuait

A proposal has not yet been provided

$25 USD em 1 dia
(0 Comentários)
0.0
$30 USD em 1 dia
(0 Comentários)
0.0
PragatiDwivedi03

• 6 years of IT experience in OOP’s and Microsoft .Net Technologies. I have developed several [url removed, login to view] are likes 1) [url removed, login to view] 2) [url removed, login to view] 3) [url removed, login to view] Mais

$25 USD em 1 dia
(0 Comentários)
0.0
davidkorg

As Project Manager and Database expert, I have developed strong skills in managing software development projects for the technology division of the company, implementing AGILE / Scrum methodologies, database design and Mais

$45 USD in 2 dias
(0 Comentários)
0.0
sajjal007

Hi. I have read your requirements and I completely understand them. I am apparent to let you know that your requirements suits my skill set & expertise. Surely I will run your project successful. I have been profes Mais

$20 USD in 3 dias
(0 Comentários)
0.0
sqldelivery

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.

$111 USD em 1 dia
(0 Comentários)
0.0
nikhilg4

We are Ex-Employees of Indian top IT firms like Microsoft, CSS, and graduates from top B schools in the country. We have a wide range of Experience in the market for more than 10 years. We are Partnered supporting deve Mais

$30 USD in 5 dias
(0 Comentários)
0.0
siddhartht

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

$25 USD em 1 dia
(0 Comentários)
0.0
speedysols6

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Mais

$31 USD em 1 dia
(0 Comentários)
0.0
gunjankh

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.

$30 USD in 2 dias
(0 Comentários)
0.0