DaveWentzel.com            All Things Data

Which Driver is my App Using

 

select 
protocol_type, 
convert(binary(4),protocol_version) AS Converted,
CASE SUBSTRING(convert(binary(4),protocol_version), 1,1)
WHEN 0x70 THEN 'SQL Server 7.0'
WHEN 0x71 THEN 'SQL Server 2000'
WHEN 0x72 THEN 'SNAC 9'
WHEN 0x73 THEN 'SNAC 10'
ELSE 'Unknown driver'
END
AS DriverVersion
from sys.dm_exec_connections

 

select 
protocol_type, 
convert(binary(4),protocol_version) AS Converted,
CASE SUBSTRING(convert(binary(4),protocol_version), 1,1)
WHEN 0x70 THEN 'SQL Server 7.0'
WHEN 0x71 THEN 'SQL Server 2000'
WHEN 0x72 THEN 'SNAC 9'
WHEN 0x73 THEN 'SNAC 10'
ELSE 'Unknown driver'
END
AS DriverVersion
from sys.dm_exec_connections

DBA Topics

Add new comment