>Hi
>
>I have a web application. The web application has "timer" inside.. and this timer must check new records. When new record appears in the table, then I need to show popup window like "You have a new message" :)
>
>The question is.. How efficiently to build this process.. which SQL command should I send to my SQL Server table for maximum performance and how to build table for this purpose.
>
>Thanks
>Denis

I think you need to look into this Notification Service Broker

http://www.informit.com/articles/article.aspx?p=473453