How to: Create Database Mail Accounts (Transact-SQL) How to: Create a Database Mail Configuration Script Using Templates (SQL Server Management Studio) How to: Configure SQL Server Agent Mail to Use Database Mail (SQL Server Management Studio) How to: Convert Stored Procedures from SQL Mail ...
The following post describes how you can configure your SQL Server to listen on a different port(s) on different IP addresses that are available on your system. This procedure applies to both SQL server 2005 and SQL server 2008.Case 1: SQL Server is installed i...
Applies to: SQL Server - Linux This article describes how to configure the Microsoft Distributed Transaction Coordinator (MSDTC) on Linux. MSDTC on Linux is supported on SQL Server 2017 (14.x) Cumulative Update 16 and later versions. Overview Distributed transactions are enabled on SQL Server on...
This post comes as a response to requests from many of our customers, who want to know the step by step process on how to configure SQL Server Database Mail to send emails using their Windows Live Mail Account or their Gmail Account. ...
How to: Configure and Execute Collaborative Synchronization (SQL Server) How to: Backup and Restore a Database (SQL Server) How to: Handle Data Conflicts and Errors for Collaborative Synchronization (SQL Server) How to: Clean Up Metadata for Collaborative Synchronization (SQL Server) How to: Deli...
Applies to: SQL Server - Linux This article describes how to configure the Microsoft Distributed Transaction Coordinator (MSDTC) on Linux. Bilješka MSDTC on Linux is supported on SQL Server 2017 starting with cumulative update 16. Overview Distributed transactions are enabled on SQL Server on Linu...
These instructions assume you want to create a highly available SQL Server deployment entirely within one Azure region. It is entirely possible to configure SQL Server clusters that span different geographic regions within Azure, or even Hybrid ...
In SQL Server Configuration Manager, expandSQL Server Native Client Configuration, right-clickClient Protocols, and then clickProperties. In theEnabled Protocolsbox, clickMove UporMove Down, to change the order in which protocols are tried, when attempting to connect to SQL Server. The top protocol...
Right-click the Replication folder, and then click Configure Distribution. Follow the Configure Distribution Wizard to: Select a Distributor. To use a local Distributor, select '<ServerName>' will act as its own Distributor; SQL Server will create a distribution database and log. To use a remo...
Azure SQL Data Warehouse Parallel Data Warehouse This article describes how to configure the Microsoft Distributed Transaction Coordinator (MSTDC) on Linux. MSDTC support on Linux was introduced in SQL Server 2019 preview. Overview https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configur...