Find IP and Port using SQL SSMS

Find IP and Port using SQL SSMS Find IP and Port of a SQL Server from a client machine. The script will not provide all the information if you are…

Read Full
67 views 20:39 2 Comments

Latest service pack to SQL Server

Apply latest service pack to standalone SQL Server We have given a Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) Enterprise Edition (64-bit) on Windows Server 2012 R2 Standard 6.3…

Read Full
63 views 11:35 2 Comments

Error : FILESTREAM feature is disable

Introduction Error - System.Data.Sqltypes.SqlClent.SqlError:FILESTREAM feature is disable. (Microsoft.SqlServer.Smo) Scenario A database backup from a test server provided to DBA team and asked to restore it on a pre-production SQL Server.…

Read Full
40 views 18:04 0 Comments

Install SQL Server 2008R2 on Windows 2012R2

Introduction Installing lower version SQL Server on a higher version of Windows Server may be problematic at times of installation. Recently we have faced such a scenario. We are sharing…

Read Full
37 views 15:51 0 Comments

Unable to begin a Distributed Transaction

Problem When your application uses the distribution transaction then you may encounter below error. Error: The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server "Linked_Server_Name"…

Read Full
33 views 19:22 0 Comments