Export (0) Print
Expand All
ABS
ALL
AND
ANY
AVG
bit
COS
COT
DAY
EXP
GO
IN
LEN
LOG
MAX
MIN
NOT
OR
PI
SET
SIN
STR
SUM
TAN
USE
VAR
Expand Minimize

FULLTEXTSERVICEPROPERTY

SQL Server 2000

Returns information about full-text service-level properties.

Syntax

FULLTEXTSERVICEPROPERTY ( property )

Arguments

property

Is an expression containing the name of the full-text service-level property. The table lists the properties and provides descriptions of the information returned.

Property Value
ResourceUsage A value from 1 (background) through 5 (dedicated).
ConnectTimeout The number of seconds that Microsoft Search Service will wait for all connections to the Microsoft® SQL Server™ database server for full-text index population before timing out.
IsFulltextInstalled The full-text component is installed with the current instance of SQL Server.

1 = Full-text is installed.
0 = Full-text is not installed.
NULL = Invalid input, or error.

DataTimeout The number of seconds that Microsoft Search Service will wait for data to be returned by Microsoft SQL Server database server for full-text index population before timing out.

Return Types

int

Examples

This example verifies that Microsoft® Search Service is installed.

SELECT fulltextserviceproperty('IsFulltextInstalled')

Here is the result set:

----------- 
1

See Also

FULLTEXTCATALOGPROPERTY

Metadata Functions

sp_fulltext_service

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft