SQL Server

Microsoft SQL Server 2016 Cluster Setup Using Hyper-V Virtual Machines

Microsoft SQL Server 2016 Cluster Setup Using Hyper-V Virtual Machines Some key points: The user which you are going to be used in SQL clustering setup must be the part of Domain Admin group and be the local administrator in both machines Hyper-V is required in case you need to use NIC teaming and use […]

Network Error while Connecting to SQL Server 2012 Express Edition

I got this error while installing a local product created in .net as front end and SQL server as back end. Everything was seems working while I try to connect to the SQL server but application was not able to be installed on the client system. I followed the under given settings for opening the […]

Set Database from Signle User Mode to Multi User in Microsoft SQL Server 2012

I encountered this error while making copy of the database in Microsoft SQL Server Management studio 2012. Server was a Virtual Machine and was stuck in the middle of the operation. After i aborted the operation the database was switched to single user. Server was not letting to switch the database from single user to […]

Microsoft SQL Server Error 233, No Process Is On The Other End Of The Pipe

Microsoft SQL Server Error 233, No Process Is On The Other End Of The Pipe Microsoft SQL Server Error 233, No Process Is On The Other End Of The Pipe, if you are getting this error, then you are at the right page. I faced this issue and by following the under given instruction, i […]

How To Know When Trigger Was Updated

In SQL server we often interested in knowing that when last time a specific trigger on a table was updated . It Requireid especially when a trigger is being update on regular bases or multiple users are allowed to update that trigger.Here comes the power of System tables in SQL SERVER to track such changes […]

How to Use Activity Monitor in Microsoft SQL Server 2008

The Activity Monitor gives us a view of current connections on an instance. The monitor can be used to determine whether we have any processes blocking other processes. To open the Activity Monitor in Management Studio, right click on the Server in the Object Explorer, then select Activity Monitor. 1. Session ID: The unique number assigned to […]