Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Rudy Panigas,
Just copy and paste the T-SQL code and execute to get the port number used by SQL server. This is how it works.
I have tested this script on the following versions
It is quick, simple and could be executed on develoopment and production servers as there are not changes being made to SQL server and/or the Window's registery.
You will need to ensure you have rights to read the register in order for the script to execute properly and must be executed on each instance (this version) to get the port number)
See how the OVER() clause was used in a live system to fix overlapping field version numbers.
Does anyone support databases that have version numbers in their name and is it really necessary/val...
One of the coolest things to release with SQL Server 2016 was “Number of Rows Read” information in...
SQL Server Integration Services (SSIS) execution is sequential by default. SQL Server Integration ...
version difference Sql server 2000