QInfo / Status Tables - ConnID format

I notice that the ConnIDs which appear in the statserver tables are not in the same hexadecimal format as we see in the T Server logs / attached data.

Here is an example from my Status table: 38845362651778950

Is this correct or should I be using a different datatype for this column or something? I’m using SQL 2005.

Is there any way to convert it?

it’s simple conversion from hex to dec. u can use MS T-SQL function “convert” for do it.

1 Like