Hi one and all
I am looking at the issue of collision detection and how to determine whether a record has changed or not.
I figure I can use CURVAL(fieldname,view) to determine whether my data has changed underneath me.
What I would like to know is for a view/table with table buffering set, can I set a filter contain only records I have modified/added without havingan extra field (dirty flag)???
Also, is collision detection inherent in SQL server????
Thanks
Geoff Scott
May all your weeds be wildflowers