michael.kaufmann (3/15/2011)
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
Actually, if you run the "correct" answer in SQL 2000, you get:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'fn_virtualservernodes'.
You need to run it with the 2 colons for it to work - although not in SQL 2005 or later. See the link in my post above.
Not sure where that leaves us, but hey.