次の方法で共有

  • [アーティクル]

FullTextService プロパティ

SQL Server のインスタンスの Microsoft Search フルテキスト サービスの実装を取得します。

名前空間:  Microsoft.SqlServer.Management.Smo
アセンブリ:  Microsoft.SqlServer.Smo (Microsoft.SqlServer.Smo.dll)

構文

'宣言
<SfcObjectAttribute(SfcObjectRelationship.Object, SfcObjectCardinality.One)> _
Public ReadOnly Property FullTextService As FullTextService
    Get
'使用
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

プロパティ値

型: Microsoft.SqlServer.Management.Smo. . :: . .FullTextService
SQL Server のインスタンスでのフルテキスト サービスの実装を示す FullTextService オブジェクトです。

説明

FullTextService オブジェクトを使用して、Microsoft Search の設定を変更できます。このオブジェクトには、フルテキスト検索カタログを保存する既定の場所などの設定が含まれています。

使用例

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()