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 more
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 more
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 more
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 more
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 … Read more
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 more