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?

Chris Houghton (3/15/2011)

---

Tested select * from ::fn_virtualservernodes() on both 2005 and 2008 clusters and it returned correct results for both.

bitbucket-25253 (3/14/2011)

---

Here we go again -- the specified as correct answer is an item to be depreciated in a future release of SQL Server and one possible answer, and the one I was unfortunate to select is currently available in all the SQL Server editions specified by the question and does work. So this question which should be teaching us something does exactly the opposite, it encourages us to use an item to be depreciated and declares the another selection as incorrect, but which is available and does work in the specified editions...

From the cited reference to justify the answer


Alas and alack woe is me ......

And now I have a suggested QOD which is:

Who is currently responsible for checking the accuracy of submitted QODs and when will they be replaced.

End of rant

Koen Verbeeck (3/15/2011)

---

So apparently all the three answers are correct?
Everybody wins!

CirquedeSQLeil (3/14/2011)

---

I was bit by the same bug. I chose the more current command that is still available and got it wrong. I tested the query of sys.dm_os_cluster_nodes and verified that it does work.

michael.kaufmann (3/15/2011)

---

[quote]

Totally agree!
Only want to add the link to the page again: http://msdn.microsoft.com/en-us/library/ms176098.aspx
Despite the versions listed (from 2005 through 2011), the correct answer is based on an older version (SQL Server 2000). Don't really get the logic--but that's life, I guess.

Regards,
Michael