Disable a trigger temporarily.

In my project I was thinking is it possible to disable all triggers temporarily? Then answer is yes. We can disable it. The alternate is we can drop them and re-create it but it's not good way. Any how to disable trigger it's not good idea because it can create a lot more issue with the data integrity....

Find Stored Procedure name with help of partial name (word).

Some times we want to find a stored procedure but don’t remember exactly sp name then it’s bit complex to find the whole name of the sp in Management Studio. But might be you know that SQL Server provides some system object from there we can easily finds the any object name. There are inbuilt tables...

Find out the used space for a Table in SQL Server

Some time we would like to know how much space table is using to store the data on a disk.So SQL Server has a built in SP to find out the used space by table.sp_spaceused '‘Tablename'once you will execute above stored procedure you will see the following result.Actually it is very useful that how much...

Mouse events on Transparent Element

Recently I am working on a project named 2011.I am working on a Document Manager Workflow Module, in that project i need to render a div element on a image element to draw some annotation. So what I wanted is to draw a div on image with transparent background and then catch a mouse click event on that...