Question: I have a (SQL 2005) stored procedure that processes a giant table and groups old data from the past (up til one year ago). It has this main steps:

* copy old data grouped to a new table
* copy recent data as is to the new table
* rename table

Now I want to log every run and every step in logging tables. However I start a transaction in the beginning so that I can rollback the whole batch if something goes wrong. But that would also rollback my logging which isn't what I want.

How can I resolve this?

Answer: 
Recording with Siebel 8.1 on [Loadrunner 11](http://forum.360logica.com/viewtopic.php?f=5&t=954) having issues,posted a question on HP and got the same comment. But usually we can try the below mentioned option

1. You can record in Siebel-Web or web (http/html) and playback as
either too (if you want to record in Siebel-Web and play back in
regular web, just copy the contents of the script to a regular web
script and save).
2. Try a proxy mode recording in LR.
3. Changing registry and disables NTLM.
4. Turn off all autocorrelation rules
5. Turn on record as URL mode (as an alternate use web\_custom\_requests())
6. Use a sniffer to capture the traffic and then build a script by hand.(Best Option)
7. Change settings on the Siebel server side as well (Enable Automation=True, EnableWebClientAutomation = TRUE)
This is going to sound belligerent, condescending and downright offensive. It is not to be meant as a reflection on you, but upon your management who has placed you in this position.

The topic of Correlation is one covered extensively in the class for LoadRunner web script development. It is the topic of a full 1/3 of the class and an additional appendix. All told some four different techniques for collecting dynamic data are covered, presented or documented as a part of the class materials. This capability, the handling of dynamic data, is a foundation tool skill.

Vardges, your management has placed you in a tough spot. Personally I would bolt for greener fields, for any management which is willing to do this to a line-of-business employee is also willing to toss that same person under the bus to salvage their own hide or a client relationship. Blaming you for something that management is unwilling to address is not a question of "if?" when training and mentoring does not occur, but only "when?" will the blame be placed on you.

James Pulley

Moderator: YahooGroups Advanced-LoadRunner, YahooGroups LoadRunner, SQAForums LoadRunner, LinkedIn LoadRunner, GoogleGroups lr-loadrunner