Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Querying SQL Server to find out if FTI is enabled

Author  Topic 

FatboYgw
Starting Member

2 Posts

Posted - 2006-08-14 : 10:20:12
Hi there,

I'm writing a small app (in VB.net) to set up a database on SQL server from scripts. The database being installed uses full-text indexing.

I'm wondering if there is a way of finding out if FTI is installed/enabled on a SQL server with a simple query, so that I can perform a check for it before starting to run through the scripts.

TIA

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-08-14 : 10:54:36
yes, you can use the FULLTEXTSERVICEPROPERTY function. here are details: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_4l89.asp




-ec
Go to Top of Page

FatboYgw
Starting Member

2 Posts

Posted - 2006-08-15 : 07:36:36
Problem solved, thanks a lot!
Go to Top of Page
   

- Advertisement -