So when REPLACE VIEW has taken exclusive rowHash lock on the dictionary, does it lock underlying table? Ex:
1. Consider view is pointing to Table A
2. Run Macro to REPLACE VIEW to point to Table B. Will Table A have exclusive lock now becuase current view is pointing to Table A ?
Do you think we will have deadlock situation at all going with View switch approach for dirty read?
Thanks for your inputs.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.