How to tell if full-text service is running in SQL 2008 from a T-SQL statement?

• Tom3w

  Default port

  Points: 1417

  More actions

  June 12, 2009 at 3:21 pm

  #201392

  In versions of SQL prior to 2008, following query would let us know whether full-text search service was running.

  SELECT fulltextserviceproperty('ResourceUsage') --is running if get 1,2,3,4 or 5.

  This query has been deprecated in SQL 2008 to always return zero.

  Is there an alternative way to check this service from T-SQL ?

  p.s. using C++, or other common programming languages', functions is not helpful in desired case.

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  June 12, 2009 at 5:55 pm

  #1008952

  Hello,

  I have not tried it, but I assume you could use xp_cmdshell to execute an SC Query against the FullText service.

  This article has sample code for doing that against other SQL Services:-

  http://sql-articles.com/blogs/startup-procedure-to-check-sql-server-status-when-restarted/

  Anyway, hopefully somebody else will come up with a simpler solution.

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group