SetDefaultFullTextCatalog Method

Database.SetDefaultFullTextCatalog Method (String)


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 AdventureWorks2012 database.
Dim db As Database
db = srv.Databases("AdventureWorks2012")

'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\MSSQL12\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.


$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2012")

$fg1 = new-object Microsoft.SqlServer.Management.Smo.FileGroup($db, "FILEGROUP2")

$df1 = new-object Microsoft.SqlServer.Management.Smo.DataFile($fg1, "newfile")
$df1.FileName = "c:\Program Files\Microsoft SQL Server\MSSQL12\MSSQL\DATA\newfile.ndf"


Return to top
© 2015 Microsoft