Server.DefaultTextMode Property
Gets or sets the Boolean property value that specifies whether the default text mode is set for the instance of SQL Server.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntax
'Declaration
Public Property DefaultTextMode As Boolean
public bool DefaultTextMode { get; set; }
public:
property bool DefaultTextMode {
bool get ();
void set (bool value);
}
/** @property */
public boolean get_DefaultTextMode ()
/** @property */
public void set_DefaultTextMode (boolean value)
public function get DefaultTextMode () : boolean
public function set DefaultTextMode (value : boolean)
Property Value
A Boolean value that specifies the whether the default text mode is set for the instance of SQL Server. If True, the default text mode is set to True. If False, the default text mode is not set False.
Remarks
Updated text:
The DefaultTextMode is an SMO setting that specifies the default value for the TextMode property of all the database objects on the instance of SQL Server. The View object, for example, supports the TextMode property. The DefaultTextMode sets the default value of this property on the instance of SQL Server.
The TextMode property specifies whether header information is generated automatically for SMO database objects that have a Text property. In SMO, the View object requires you to specify the definition of the view by using a Transact-SQL statement in the Text property.
This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.
Example
srv.DefaultTextMode = True
Thread Safety
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.
See Also
Reference
Server Class
Server Members
Microsoft.SqlServer.Management.Smo Namespace
Other Resources
How to: Get and Set a Property in Visual Basic .NET
Setting Properties
Managing Servers
Change History
Release |
History |
New content:
|