Scenario:
A new contracting firm takes responsibility for a server farm. The previous contractor left no documentation.
1. Is there a way to query windows services running to see if SQL is running on which machines (or is there a way to verify with one script which machines are running SQL Server)?
2. Is there a way to query the registry to see what ports SQL is using (if it might be set to something else that the default)?
All help is appreciated!
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.