Need to delay SQL injection while returning control immediately
Posted on 2007-11-16
I'm trying to write a sql trigger for an application that requires a field to be changed after specific period of time has elapsed.
I understand that using waitfor and xp_cmdshell will not return control immediately, so while my trigger works, we have the unfortunate side effect of the application locking up until the delay time has passed.
Is there any way to delay injecting this code without interrupting normal program flow?