Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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)

member SetDefaultFullTextCatalog : 
        catalog:string -> unit


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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft