question

rudrapbiswas avatar image
rudrapbiswas asked

Modify stored procedre w/o Application downtime

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
sql-server-2012mssql2012
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Ange avatar image
Ange answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.