Is this clause set to no as default or do I need to add this in all my connection strings? I want to make sure that multi users can read/write to the remote tables with out any problems.

How can I write(update) data to a remote table with only the record locked and not the table?