It is possible. you said timeout, So not mensioned. is it Server timeout are Application Timeout..etc.
I think NeoPa gave some refrence pages.
that will help you.
hi Neo and hari .thanks for your replies.
I am using sql 2005. I searched in the link you gave me. i couldn't find a trigger that is needed.
here is the scenario,
I want to call an sql trigger on a NO INSERT condition on a table for a given time(i want a trigger to be executed when no rows has been inserted in a table for 2 seconds). It is just opposite to TRIGGER ON INSERT. I need one which should be TRIGGER ON NO INSERT for a give timeout interval.
The timeout is what i define. it is not the server timeout.
Now i have one more idea. How will i execute a sql code in a procedure every 2 seconds(time may even be in milliseconds). Can i loop a code every 2 seconds. Can you help me on this ?
Thank you once again for taking time to reply.