>I have an application that will be driven from a control table on SQL Server. In other instances, I just poll SQL Server every 10 seconds or so to see if there are any jobs. Is there a more effective way of doing this?
>
>Thanks,
>Mike
Yes. SQLServer supports COM, so you could do that and BindEvents to its events.