We have lot of stored procedures in our database and Application majorly backed by the stored procs. Often we need to modify the stored procedures. In order to do so, we are bringing the App servers down ad make the db changes and then deploy the App code. It takes a good amount of time and keeping the App down. IS there any way we can alter/modify stored proc online and the same query I have for column alter/modification as well. Is there anything similar we can achieve in sql server 2016
Why do you need to do it off line? I always update my stored procedures live. So long as you have tested them on a development database and are 100% sure they work I don't see any reason why you can't do it live.