Did you know you can start the SQL Browser service from the command line and watch as the UDP requests on 1434 fly in?
Your location of the file may vary, but you just use the -c switch like so:
c:\program files\microsoft sql server\90\shared>sqlbrowser.exe -c
Monthly Archives: April 2010
Cluster Diagnostics
Installing SQL 2008 on my existing 2005 cluster seemed to have broken my clustered 2005 SSIS service. It stopped starting successfully around the time of the install and the instance started using the SSIS 10 service - although I didn't know this.
I found out by using a tool called clusterdiag.exe from microsoft. … Continue Reading ››
I found out by using a tool called clusterdiag.exe from microsoft. … Continue Reading ››