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)
Syntax
'Declaration
Public Sub SetDefaultFullTextCatalog ( _
catalog As String _
)
'Usage
Dim instance As Database
Dim catalog As String
instance.SetDefaultFullTextCatalog(catalog)
public void SetDefaultFullTextCatalog(
string catalog
)
public:
void SetDefaultFullTextCatalog(
String^ catalog
)
member SetDefaultFullTextCatalog :
catalog:string -> unit
public function SetDefaultFullTextCatalog(
catalog : String
)
Parameters
- catalog
Type: System.String
A String value that specifies the name of the default full-text catalog.
Remarks
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.
Examples
'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.
fg1.Create()
'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.
df1.Create()
'Set the new default file group for the database.
db.SetDefaultFileGroup(fg1.Name)