Hi All, Does anybody know what will be the impact if i modify the view definition while its being used by another process/connection. Regards, Amit
I think there will not be any, until unless that changed view is executed next time the old plan will be in cache to process the tasks. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Some client apps (esp. using ODBC connection) may be unpleasantly surprised, and need the link to the view to be refreshed. And of course if the client app refers to any column from the view that will now be dropped, you have another problem.
