Database.SetDefaultFullTextCatalog Method

Sets the default full-text catalog for the database.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public void SetDefaultFullTextCatalog(
	string catalog


Type: System.String
A String value that specifies the name of the default full-text catalog.

This method sets the default full text catalog. Existing full-text catalogs can be referenced by using the FullTextCatalogs property. New full-text catalogs can be added by using the FullTextCatalog constructor.

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server

'Reference the AdventureWorks database.
Dim db As Database
db = srv.Databases("AdventureWorks")

'Define a FileGroup object called SECONDARY on the database.
Dim fg1 As FileGroup
fg1 = New FileGroup(db, "FILEGROUP2")

'Call the Create method to create the file group on the 
'instance of SQL Server.

'Define a DataFile object on the file group and set 
'the FileName property.
Dim df1 As DataFile
df1 = New DataFile(fg1, "newfile")
df1.FileName = _
"c:\Program Files\Microsoft SQL Server\MSSQL10\MSSQL\Data\newfile.ndf"

'Call the Create method to create the data file on the 
'instance of SQL Server.

'Set the new default file group for the database.

Community Additions