Covert varbinary data type to Varchar
Script:
SELECT thread_address,CONVERT(VARCHAR(MAX),thread_address,1) thread_address_converted FROM sys.dm_os_threads
Covert varbinary data type to Varchar
Script:
SELECT thread_address,CONVERT(VARCHAR(MAX),thread_address,1) thread_address_converted FROM sys.dm_os_threads