By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT ConnectionProperty('net_transport') AS [Net transport],
ConnectionProperty('protocol_type') AS [Protocol type]
| Net transport | Protocol type |
|---|---|
| Shared memory | TSQL |