The Operation Could Not Be Performed Because OLE DB Provider “SQLNCLI11” For Linked Server Was Unable To Begin A Distributed Transaction

Issue: The operation could not be performed because OLE DB provider “MSOLEDBSQL” for linked server “XXXXXX” was unable to begin a distributed transaction. Fix: There has been a lot of times where we can encounter this error – “The operation could not be performed because OLE DB provider “SQLNCLI11” for the linked server was unable to... » read more

TeamViewer PC Remote Control

https://www.teamviewer.com/en-us/ Cloud-based platform with intuitive features to securely and remotely access, control and support any device, across platforms — from anywhere, anytime. Download https://www.teamviewer.com/en-us/teamviewer-automatic-download/

Sysinternals

https://docs.microsoft.com/en-us/sysinternals/ The Sysinternals web site was created in 1996 by Mark Russinovich to host his advanced system utilities and technical information. Whether you’re an IT Pro or a developer, you’ll find Sysinternals utilities to help you manage, troubleshoot and diagnose your Windows systems and applications. RamMap – list of application taken up RAM memory.

SQL Server RS.exe Utility

rs.exe SQL Server 2012 D:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn SQL Server 2019 D:\Program Files\Microsoft SQL Server Reporting Services\Shared Tools\ Error: ‘rs’ is not recognized as an internal or external command Solution: Per MS’s site it’s anticipating this utility to be in “…\Microsoft SQL Server\###\Tools\Binn” so copy the rs files over to: D:\Program Files (x86)\Microsoft SQL... » read more

Access iPad/iPhone Photos and Videos from PC

In order to access photos and videos stored on your iPad/iPhone device, you have to download and install iTunes and transfer files via iTunes software. You CAN NOT access the photos and videos directly using USB cable connection. Step 1. Connect your iPad to your PC via a USB or WiFi. Step 2. Click the... » read more

Copy Files Between Two Computers

When copying files between two computer on the network, you can either 1) remote desktop on to the computer and copy there or 2) on your local computer, open up folder with the following location… \\Server01\D$\Folder01 Option #2 coping files from your local computer will be faster.