Condividi tramite

  • Articolo

Proprietà FullTextService

Ottiene l'implementazione del servizio Full-text Microsoft Search per l'istanza di SQL Server.

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
<SfcObjectAttribute(SfcObjectRelationship.Object, SfcObjectCardinality.One)> _
Public ReadOnly Property FullTextService As FullTextService
    Get
'Utilizzo
Dim instance As Server
Dim value As FullTextService

value = instance.FullTextService

[SfcObjectAttribute(SfcObjectRelationship.Object, SfcObjectCardinality.One)]
public FullTextService FullTextService { get; }

[SfcObjectAttribute(SfcObjectRelationship::Object, SfcObjectCardinality::One)]
public:
property FullTextService^ FullTextService {
    FullTextService^ get ();
}

[<SfcObjectAttribute(SfcObjectRelationship.Object, SfcObjectCardinality.One)>]
member FullTextService : FullTextService

function get FullTextService () : FullTextService

Valore proprietà

Tipo: Microsoft.SqlServer.Management.Smo. . :: . .FullTextService
Oggetto FullTextService che specifica l'implementazione del servizio Full-text nell'istanza di SQL Server.

Osservazioni

The FullTextService object can be used to change the settings for Microsoft Search. This includes settings such as the default location to store full-text search catalogs.

Esempi

Visual Basic

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")
'Reference the ProductCategory table.
Dim tb As Table
tb = db.Tables("ProductCategory", "Production")
'Define a FullTextCatalog object variable by specifying the parent database and name arguments in the constructor.
Dim ftc As FullTextCatalog
ftc = New FullTextCatalog(db, "Test_Catalog")
ftc.IsDefault = True
'Create the Full Text Search catalog on the instance of SQL Server.
ftc.Create()
'Define a FullTextIndex object varaible by supplying the parent table argument in the constructor.
Dim fti As FullTextIndex
fti = New FullTextIndex(tb)
'Define a FullTextIndexColumn object variable by supplying the parent index and column name arguements in the constructor.
Dim ftic As FullTextIndexColumn
ftic = New FullTextIndexColumn(fti, "Name")
'Add the indexed column to the index.
fti.IndexedColumns.Add(ftic)
fti.ChangeTracking = ChangeTracking.Automatic
'Specify the unique index on the table that is required by the Full Text Search index.
fti.UniqueIndexName = "AK_ProductCategory_Name"
'Specify the catalog associated with the index.
fti.CatalogName = "Test_Catalog"
'Create the Full Text Search index on the instance of SQL Server.
fti.Create()

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = $srv.Databases.Item("AdventureWorks2008R2")
$tb = $db.Tables.Item("ProductCategory", "Production")
$ftc = new-object Microsoft.SqlServer.Management.Smo.FullTextCatalog($db, "Test Catalog")
$ftc.IsDefault = $TRUE
$ftc.Create()
$fti = new-object Microsoft.SqlServer.Management.Smo.FullTextIndex($tb)
$ftic = new-object Microsoft.SqlServer.Management.Smo.FullTextIndexColumn($fti, "Name")
$fti.IndexedColumns.Add($ftic)
$fti.ChangeTracking = [Microsoft.SqlServer.Management.Smo.ChangeTracking]::Automatic
$fti.UniqueIndexName = "AK_ProductCategory_Name"
$fti.CatalogName = "Test Catalog"
$fti.Create()