I'm using SSMS 18 and using a connection with ApplicationIntent=ReadOnly parameter in C# AppConfig for executing some stored procedures, these procs are inserted in local db and this is my question: stored procedures which insert data into temp or non temp table can still insert, update, delete records even though connection is with ApplicationIntent=ReadOnly ?