Thanks - this works fine...

BEGIN TRAN;

DECLARE @bind_token varchar(255);

EXECUTE sp_getbindtoken @bind_token OUTPUT

SELECT @bind_token AS Token;

COMMIT TRAN

GO

...running it several times returns

jNN:fZ63e1K3Z2CE1KkC1=5---.RH---

ZQ/Ka[U;b1O3VV0I>DLZ[]5----QJ---

[T;?]BL7^QSQJh_PaOl@--5---/UJ---

;_0QPEcQeaKT@6^@?VH`<-5----jF---

...and so on.

Is there any guarantee that this value is unique?

We're using...

BEGIN TRAN;

update TESTTABLE set Title='MR' where StaffID='2027-sso'

DECLARE @bind_token varchar(255);

EXECUTE sp_getbindtoken @bind_token OUTPUT

SELECT @bind_token AS Token;

COMMIT TRAN

GO

Still get the same Token value every time

Paul Rony (1/9/2009)

---

We use sp_getbindtoken inside an insert/update trigger in our workflow engine. Just as you describe, we need a way to track all changes within a single transaction,...