Returns fields in a locator string.
sp_helplocator value
is the value of the locator string that identifies a transaction in the stable queue.
sp_helplocator "000000000003ad0000022d4d000b00022d4d00061e0035000000000000000000"
Returns the fields in the locator string with the value specified, as follows:
item hex_value value Generation ID 0000 0 txid_page 00022d4d 142669 txid_row 0006 6 log_ts_high 0000 0 log_ts_low 0003ad00 240896 opid_page 00022d4d 142669 opid_row 000b 11 op_code 1e 30 conn_id 0035 53
When listing fields in a locator string, the following result set is returned:
Column |
Datatype |
Description |
|---|---|---|
item |
varchar(20) |
Name of the field |
hex_value |
varchar(10) |
Hexadecimal value of the field |
value |
varchar(10) |
Decimal value of the field |
sp_helplocator is for use primarily in troubleshooting procedures.
You can use sp_helplocator to return the fields in locator values returned by sp_helplastcommit.
When an error occurs, an error message is returned.
sp_helplastcommit, sp_helprep
