John:

>>Actually you can create a new RV completely in *code*.

Thats what I meant when I said rebuild it. If you want to change the SQL prop, you've got to close the tables in the DE, drop View from DBC, rebuild it then add it back. That a lot of overhead. OTOH, an SPT cursor can be required and the new cursor just overwrites the old.

>>I see no huge difference between code to recreate a RV and code to recreate a >>SP.

There is never a need to change a SP during runtime.

This thread is getting old, let talk about something else :)

Regards
Charlie