PowerUpSQL icon indicating copy to clipboard operation
PowerUpSQL copied to clipboard

Add the listening TCP port to the Get-SQLServerInfo function output.

Open nullbind opened this issue 7 years ago • 0 comments

Add the listening TCP port to the Get-SQLServerInfo function output.

Option #1: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-connections-transact-sql?view=sql-server-2017

select local_tcp_port from sys.dm_exec_connections where local_net_address is not null

Option #2 xp_regread from the mssql service settings.

nullbind avatar Aug 14 '18 17:08 nullbind