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 …

Read more

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 …

Read more

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 …

Read more