to do some action for insert/update u create trigger on that table.

so u need not check every 5 mins right ?
Regards,
Santhosh

> ----------
> From: Usman Farhat[SMTP:Usman.[Email Address Removed] Sent: Monday, May 26, 2003 5:45 PM
> To: LazyDBA.com Discussion
> Subject: Insertion Check
>
> Hi Everyone,
> I got to check a table after every five minutes that if there is any
> record inserted in it ,if there is some new row inserted i got to carry
> out some specific actions. So my problem is to create a procedure that
> checks every five minutes on a particular table whether there is something
> new inserted in this table or no. How can i carry out this process ? Any
> Idea ?
> Regards,
> Usman
>
> --------------------------------------------------------------------
> NOTA CONFIDENZIALE:
> Questo messaggio ed i suoi allegati sono indirizzati esclusivamente
> alle persone indicate in testa e possono contenere informazioni
> confidenziali. Se avete ricevuto il messaggio per sbaglio, sappiate
> che qualunque utilizzo improprio del contenuto è proibito, Vi
> preghiamo quindi di inoltrarlo immediatamente al mittente e di
> cancellare il messaggio. Per qualsiasi informazione vi inivitiamo a
> contattarci scrivendo a [Email Address Removed]
>
> Grazie
>
> CONFIDENTIALITY NOTICE:
> This message and its attachments are addressed solely to the persons
> above and may contain confidential information. If you have received
>
> the message in error, be informed that any use of the content hereof
> is prohibited. Please return it immediately to the sender and delete
> the message. Should you have any questions, please contact us by replying
>
> to [Email Address Removed]
> Thank you
> --------------------------------------------------------------------
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]
MS Sql Server LazyDBA home page