SQLServerCentral / Administering / SQL Server 2005 / how to know the instance is a failover cluster? / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 00:47:21 GMT20RE: how to know the instance is a failover cluster?http://www.sqlservercentral.com/Forums/Topic964109-146-1.aspxThe T-SQL I posted above does exactly that.Wed, 11 Aug 2010 05:22:12 GMTGilaMonsterRE: how to know the instance is a failover cluster?http://www.sqlservercentral.com/Forums/Topic964109-146-1.aspxHi Gail,I want to know through which command i can know that my server instance is clustered or not....in SQL Server 2005Wed, 11 Aug 2010 05:07:44 GMTmohd.sqlRE: how to know the instance is a failover cluster?http://www.sqlservercentral.com/Forums/Topic964109-146-1.aspx[code="sql"]SELECT SERVERPROPERTY('IsClustered') as IsFailoverClusterNode[/code]Thu, 05 Aug 2010 04:29:37 GMTGilaMonsterhow to know the instance is a failover cluster?http://www.sqlservercentral.com/Forums/Topic964109-146-1.aspxHi Friends,I want to know how to know my current instance is a failover cluster instance?sorry for my bad english.Thanks in advance. M.I.Thu, 05 Aug 2010 04:20:10 GMTMSQLDBA