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
459 views 20:39 2 Comments

Find user activity without any Auditing

How to find out user activity on database without any particular Auditing Sometime you may need to find out who ran some script or who is accessing the database or…

Read Full
654 views 20:31 0 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
310 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
217 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
207 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
327 views 19:22 0 Comments