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 …
Read moreMicrosoft SQL Server 2016 Cluster Setup Using Hyper-V Virtual Machines
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 …
Read moreNetwork Error while Connecting to SQL Server 2012 Express Edition
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 …
Read moreSet Database from Signle User Mode to Multi User in Microsoft SQL Server 2012
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 …
Read moreMicrosoft SQL Server Error 233, No Process Is On The Other End Of The Pipe
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 …
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 …
Read moreHow to Use Activity Monitor in Microsoft SQL Server 2008
