Is it possible to deny all new connections temporarily in SA12 and/or SA16? This would be great for updating the schema and debugging.
Bjarne Anker Maritech Systems Norway
You can do that via the system procedure sa_server_option when setting the options "ConnsDisabled" or "ConnsDisabledForDB" to YES, i.e. with something like
and reset them to 'NO' afterwards.
Confine that very old FAQ here including sample code:
answered 02 Mar '15, 03:18
See the answer to the question How to limit the remote access to the database server? here on this forum.
answered 02 Mar '15, 03:19