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 Sub SetDefaultFullTextCatalog ( _
    catalog As String _
Dim instance As Database
Dim catalog As String

public void SetDefaultFullTextCatalog(
    string catalog
void SetDefaultFullTextCatalog(
    String^ catalog
member SetDefaultFullTextCatalog : 
        catalog:string -> unit 
public function SetDefaultFullTextCatalog(
    catalog : 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.