Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

SQL Script to check SQL Server cluster Nodes. Expand / Collapse
Author
Message
Posted Monday, March 14, 2011 9:01 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 1:05 AM
Points: 908, Visits: 1,496
Comments posted to this topic are about the item SQL Script to check SQL Server cluster Nodes.

Thanks.
Post #1078093
Posted Monday, March 14, 2011 9:15 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 10:58 AM
Points: 5,333, Visits: 25,272
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

Important
This Microsoft SQL Server 2000 system function is included for backward compatibility. We recommend that you use sys.dm_os_cluster_nodes (Transact-SQL instead.


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


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1078095
Posted Monday, March 14, 2011 11:04 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:58 PM
Points: 17,854, Visits: 15,803
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

Important
This Microsoft SQL Server 2000 system function is included for backward compatibility. We recommend that you use sys.dm_os_cluster_nodes (Transact-SQL instead.


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

And now I have a suggested QOD which is:



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.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1078127
Posted Monday, March 14, 2011 11:15 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:39 AM
Points: 1,880, Visits: 2,846
Agree, tested
SELECT * FROM sys.dm_os_cluster_nodes 
SELECT * FROM fn_virtualservernodes()

on 2k8 R2 and both worked...

**hits head against wall** Need to read questions.....


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1078128
Posted Monday, March 14, 2011 11:20 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:43 AM
Points: 1,939, Visits: 1,162
I also got wrong and choosed DMV

Malleswarareddy
I.T.Analyst
MCITP(70-451)
Post #1078131
Posted Monday, March 14, 2011 11:37 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
I too selected the wrong "correct" answer because I assumed you wouldn't choose to use the deprecated version, when there is a current fully supported version that works on all of the editions that are specified. Especially since the current term instance was used, and not the old "virtual server" term.
Post #1078134
Posted Tuesday, March 15, 2011 12:33 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 3:53 PM
Points: 2,278, Visits: 3,801
Correction must be made regarding the wrong answer that is chosen as the right one.

Infact I chose the last option and got it right as I was thinking the first one to be wrong.

I guess the error must have crept in inadvertently, we all learn from it


Mohammed Moinudheen
Post #1078145
Posted Tuesday, March 15, 2011 12:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 14, 2014 5:48 PM
Points: 18, Visits: 86
Are you sure it's going to be called SQL 2011?
Post #1078146
Posted Tuesday, March 15, 2011 12:36 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 1:52 PM
Points: 13,368, Visits: 11,148
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?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1078147
Posted Tuesday, March 15, 2011 1:04 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 10:14 AM
Points: 4,050, Visits: 5,366
Given a choice between a function marked for deprecation and a fully functional DMV, I believe most of us would rather choose the DMV, as it would prevent re-work at a later stage.

Ah well, c'est la vie....


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1078156
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse