SPT cursor is basically a read-only view, which can be made updatable. See How to Create Updatable Views by Using SQL Passthrough mskb #138094.


>Weird... I never think of it as an actual cursor, because I don't (can't?) use it to update. You're right, a TABLEUPDATE() does it. Doesn't seem like I can set it to buffering = 1, even if I wanted to (i get an error telling me it HAS to be Optimistic).
>
>Anyway, this seems to be the best workaround. Thanks again Sergey!