Class ServerWideConfigurationSchema.DataContext
- Namespace
- LinqToDB.Tools.DataProvider.SqlServer.Schemas
- Assembly
- linq2db.Tools.dll
public class ServerWideConfigurationSchema.DataContext- Inheritance
-
ServerWideConfigurationSchema.DataContext
- Extension Methods
Constructors
DataContext(IDataContext)
public DataContext(IDataContext dataContext)Parameters
dataContextIDataContext
Properties
Configurations
sys.configurations (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Contains a row for each server-wide configuration option value in the system.
See sys.configurations.
public ITable<ServerWideConfigurationSchema.Configuration> Configurations { get; }Property Value
TimeZoneInfo
sys.time_zone_info (Transact-SQL)
Applies to: √ SQL Server 2016 (13.x) and later √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics
Returns information about supported time zones. All time zones installed on the computer are stored in the following registry hive:
KEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones.
See sys.time_zone_info.
public ITable<ServerWideConfigurationSchema.TimeZoneInfo> TimeZoneInfo { get; }Property Value
TraceCategories
sys.trace_categories (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
Similar event classes are grouped by a category. Each row in the sys.trace_categories catalog view identifies a category that is unique across the server. These categories do not change for a given version of the SQL Server Database Engine.
For a complete list of supported trace events, see SQL Server Event Class Reference.
> IMPORTANT! This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use Extended Event catalog views instead.
See sys.trace_categories.
public ITable<ServerWideConfigurationSchema.TraceCategory> TraceCategories { get; }Property Value
TraceColumns
sys.trace_columns (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
The sys.trace_columns catalog view contains a list of all trace event columns. These columns do not change for a given version of the SQL Server Database Engine.
For a complete list of supported trace events, see SQL Server Event Class Reference.
important
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use Extended Event catalog views instead.
See sys.trace_columns.
public ITable<ServerWideConfigurationSchema.TraceColumn> TraceColumns { get; }Property Value
TraceEventBindings
sys.trace_event_bindings (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
The sys.trace_event_bindings catalog view contains a list of all possible usage combinations of events and columns. For each event listed in the trace_event_id column, all available columns are listed in the trace_column_id column. Not all available columns are populated each time a given event occurs. These values do not change for a given version of the SQL Server Database Engine.
For a complete list of supported trace events, see SQL Server Event Class Reference.
important
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use Extended Event catalog views instead.
public ITable<ServerWideConfigurationSchema.TraceEventBinding> TraceEventBindings { get; }Property Value
TraceEvents
sys.trace_events (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
The sys.trace_events catalog view contains a list of all SQL trace events. These trace events do not change for a given version of the SQL Server Database Engine.
> IMPORTANT! This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use Extended Event catalog views instead.
For more information about these trace events, see SQL Server Event Class Reference.
See sys.trace_events.
public ITable<ServerWideConfigurationSchema.TraceEvent> TraceEvents { get; }Property Value
TraceSubclassValues
sys.trace_subclass_values (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
The sys.trace_subclass_values catalog view contains a list of named column values. These subclass values do not change for a given version of the SQL Server Database Engine.
For a complete list of supported trace events, see SQL Server Event Class Reference.
important
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use Extended Event catalog views instead.
public ITable<ServerWideConfigurationSchema.TraceSubclassValue> TraceSubclassValues { get; }Property Value
Traces
sys.traces (Transact-SQL)
Applies to: √ SQL Server (all supported versions)
The sys.traces catalog view contains the current running traces on the system. This view is intended as a replacement for the fn_trace_getinfo function.
For a complete list of supported trace events, see SQL Server Event Class Reference.
important
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use Extended Event catalog views instead.
See sys.traces.
public ITable<ServerWideConfigurationSchema.Trace> Traces { get; }