How do I programatically determine which port a SQL Server is running on?

How do I programatically determine which port a SQL Server is running on?/*Wrapper script for xp_readerrorlogAuthor: Ralph WillgossDate: 2nd Oct 2012This script cycles through all logs files, looking for the listening port.Normally you have to specify the log file one by one, the script removes the need for that.Param ref for: xp_readerrorlog1. Value of error log file you want to read: 0 = current, 1 = Archive #1, 2 = Archive #2, etc...2. Log file type: 1 or NULL = error log, 2 = SQL Agent log3. ......

Posted On Monday, November 26, 2012 8:16 PM

How do I recycle an IIS App pool with Powershell?

Reference implementation of a Powershell script to recycle app pools, in response to Rick's post:http://www.west-wind.c... 2003 & II6C:\WINDOWS\system32>c... iisapp.vbs /a AppPoolName /rWindows 2008 IIS7C:\WINDOWS\system32\ine... recycle apppool "MyAppPool"Restart-WebAppPool cmdlet# File: RecycleAppPool.ps1# Author: Ralph Willgoss# Date: 2nd Oct 2012# Reference:# http://stackoverflow.com/qu... ......

Posted On Sunday, November 25, 2012 10:36 AM

How do I programatically determine which port a SQL Server is running on?

How do I programatically determine which port a SQL Server is running on?
[The original post has been moved to here, due to issues with updating the original]

Posted On Sunday, November 25, 2012 10:20 AM