Jeff,

THe date approach as suggested above also takes SPID into consideration, which is suppose to be unique for any number of concurrent connected users to the database. Hence at any...

Following sample generates uniqueid but does not store in a table.

DECLARE @IntTransactionID bigint, --Set @IntTransactionID@dteCurrentDate datetime 

SET @dteCurrentDate = GETDATE()

--Genreate unique transaction id

SET @IntTransactionID = CAST(CAST(@@SPID AS VARCHAR(10)) +...