GilaMonster (1/14/2009)

Ok, I'm confused. You didn't mention anything about service broker before.

Wouldn't it be possible...

Last time I tried writing my own clr to send udp messages, it wouldn't compile because of security reasons sql server imposed on the code. (no udp was allowed) I...

I have looked into querynotification before and have done it this way as a test.

However there is a lot more overhead than just sending a udp message which is minimal...

I have triggers that call a stored procedure that sends a message using service broker.

However this is all contained within one system, and transaction could not fail because messages are...

I have used the message queue before and it works very effectively.

It's too bad however I can't use it to send a udp message to listening clients.

Maybe 2008 has a...

Ok, instead of giving me problems, how about providing a solution.

These tables are not (data) are not changed frequently, and the data is cached on the clients software.

When the data...

so the best way to do it is to set a trigger for afterupdate / afterinsert / afterdelete

populate another table with :

changedtablename, changeddate, changedvaluestring

Have my service process run polling...

2005 is a bit antiquated these days. Why not jump to 2008 since you are a late adopter, it should be justifiable.

I realize you guys aren't mind readers, maybe I should restate the requirements to say lowest possible positive unused value.

I found that I already had an identity set, so...

the plan would be to use it as the key in an insert statement.

sounds good to me, thanks.

yea, sorry I guess I meant lowest unused.

if 1,2,4,5 are used, then 3 would be a result.

don't you guys have jobs?

run the cursor and print the where clause that the cursor defines, and then you have both.

except is faster I concede, but unless your dealling with a million records, its good to learn about cursors.