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)
If you are recording your scripts using Web http/html you can use automatic correlation. For automatic correlation go to Design Studio
If you are unable to find the value there,then you must correlate manually using **web\_reg\_save\_param** by giving the left and right boundaries.