Koen Verbeeck (3/15/2011)
When I run "select * from ::fn_virtualservernodes()", this returns no error but an empty resultset (I don't run any failover cluster, so that is to be expected).What is the difference between this statement and the "correct" answer?
Yes, I'm confused by that as well. It's SQL 2000 syntax (see this link) but works fine in later versions too.