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 sql frenzy,
This procedure uses xsp_cmdshell to get the host IP address, hence it is slow to execute depending on the number of process.
The usage is exec usp_GetConnectionInfo