Get Live Help
A Foglight for SQL Server view that provides more detailed information than what is available on the main window. Often contains charts or tables showing SQL Server or Windows statistics or objects.
DTC (Distributed Transaction Coordinator) service is an integral component of Microsoft Windows (on Windows 2003 and higher versions), and is also available as part of the SQL Server installation if a previous version of Windows is used. This service is responsible for coordinating distributed transactions, that is, transactions that involve multiple resource managers, such as databases, message queues, and file systems.
DTS (Data Transformation Services) is a SQL Server component which provides a set of tools that allow extracting, transforming and consolidating data from various sources (for example, Oracle database, Excel spreadsheet or Microsoft Access) into single or multiple destinations that use uniform SQL Server format.
DTS can be customized to efficiently remap columns, convert data types, and change the database schema.