Author: Alexander Chigrik

SQL Server

Troubleshooting SQL Server 2016 Snapshot Replication

Troubleshooting SQL Server 2016 Snapshot Replication If you have problems with SQL Server 2016 snapshot replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because some SQL Server 2016 snapshot replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time […]

SQL Server

Troubleshooting SQL Server 2016 Merge Replication

Troubleshooting SQL Server 2016 Merge Replication If you have problems with SQL Server 2016 merge replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because some SQL Server 2016 Merge replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time […]

SQL Server

Troubleshooting SQL Server 2016 Transactional Replication

Troubleshooting SQL Server 2016 Transactional Replication If you have problems with SQL Server 2016 transactional replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because some SQL Server 2016 Transactional replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time […]

SQL Server

Troubleshooting problems with linked servers in SQL Server 2016

Troubleshooting problems with linked servers in SQL Server 2016 If you have problems with linked servers in SQL Server 2016, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because some SQL Server 2016 linked servers bugs were fixed in SQL Server service packs, you should install the latest SQL Server service […]

SQL Server

Troubleshooting Upgrading to SQL Server 2016

Troubleshooting Upgrading to SQL Server 2016 Should you have problems with upgrading to SQL Server 2016, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requirements. To upgrade to SQL Server 2016, you should have the following hardware: – Intel or compatible platform with processor speed: 1.4 GHz minimum for a 64-bit x64 2.0 GHz or faster […]

SQL Server

Troubleshooting SQL Server 2016 installation

Troubleshooting SQL Server 2016 installation If you have problems with SQL Server 2016 installation, review this troubleshooting checklist to find potential solutions. 1. Check the hardware requirements. To install SQL Server 2016, you should have the following hardware: – Intel or compatible platform with processor speed: 1.4 GHz minimum for a 64-bit x64 2.0 GHz or faster recommended – Memory […]

SQL Server

Some useful undocumented SQL Server 2016 extended stored procedures

Some useful undocumented SQL Server 2016 extended stored procedures In this article, you can find the description of some useful undocumented SQL Server 2016 extended stored procedures. xp_enum_oledb_providers This extended stored procedure can be used to get the list of all available OLE DB providers. It returns Provider Name, Parse Name and Provider Description. Syntax: EXECUTE xp_enum_oledb_providers To get a […]