Blog

15-Jun-2010
My First article on SQL SERVER Central about Access variables values from Trigger

I am glad to inform you all that, my article on "Accessing variable from Trigger", which I wrote a few days back, have been published by "SQL SERVER CENTRAL" site

13-Jul-2009
SQL SERVER: Use CONTEXT_INFO

Recently I have following situation: I don't need to execute trigger's code on some condition, like if it is called from particular stored procedure. If data is being updated from any other places, like application, or any other stored procedures, trigger code should be executed, but when one particular Stored Procedure is updating data to that table, it should not allow to do so.