Hi,
You can do something like this:
Create a stored procedure as:
select top 1 e.EventID, e.EventName, ....
from dbo.events e
order by e.EventID desc
and call this stored procedure every 2 seconds and check in the front end whether this event is fetched. If not, then add it to display otherwise ignore it.
I still don't think this is a good idea but since you do not have control over the insert stored procedure, this could be the only way you can do it.
If you have control over the insert stored procedure, then just insert the following just after the insert statement:
declare @newEventID bigint
set @newEventID = @@IDENTITY
select e.EventID, e.EventName, ....
from dbo.events e
where e.EventID = @newEventID
Hope this helps.
Regards,
Nayan