I need a stored proc which will monitor an update and if nothing happens raise an error.
For example, I set a datetime variable (@varDate) as argument of the stored proc:
if DateColumn isn't updated in MyTable ( or @varDate >= DateColumn value ) after 30 seconds, I want to raise an error.
but if DateColumnis updated in MyTable (or @varDate < DateColumn value) before 30 seconds, I want to return the new updated datetime.
Could you tell me it is dangerous for the scalability of Sql Server 2005 ?
IE: I don't want a trigger because I want to call the stored proc from a webservice.
Thanks in advance for your help.