I had an interesting question pop up today. When a SQL 2008 (in this case) instance is configured as a witness server, what exactly is modified on the instance and what changes as far as processes, etc. running are modified on that instance, aside from listening on the endpoint?
In more basic terms, what exactly happens on a witness instance that allows it to perform its witness function?
Thanks,
Jason