>>BTW, how can we search for a specific thread ID ?
>
>Just enter the thread ID in the Message ID. A thread ID is the first message ID of the thread.

Thanks. BTW, I'm not sure how to read the results

set statistics TIME ON
/****** Script for SelectTopNRows command from SSMS  ******/
Select * from [AdventureWorks].[Production].[TransactionHistory] WHERE TransactionID = 
(Select Top 1 [TransactionID] from [AdventureWorks].[Production].[TransactionHistory]
Order By NewID() )

SELECT TOP 1 [TransactionID]
      ,[ProductID]
      ,[ReferenceOrderID]
      ,[ReferenceOrderLineID]
      ,[TransactionDate]
      ,[TransactionType]
      ,[Quantity]
      ,[ActualCost]
      ,[ModifiedDate]
  FROM [AdventureWorks].[Production].[TransactionHistory] order by NEWID()