How to set transaction isolation level as read uncommitted as default for users

Question

Is it possible to set the transaction isolation level to read uncommitted for users by default in MS SQL Server Management Studio 2012?

I was thinking it could either be done through editing a config file or changing a reg key but i haven't been able to locate anything that would change this yet.

Answer 1

As far as I know you can't change the default lock level.

For workloads with a lot of reads and fewer writes, you can avoid blocking queries with multiversion concurrency control. That's the default for Postgres and Oracle. In SQL Server, MVCC is called "read committed snapshot", and you can enable it with:

ALTER DATABASE YourDb SET READ_COMMITTED_SNAPSHOT ON;

Answer 2

You can’t. The default isolation level for all SQL Server databases is Read Committed, and your only option is to set the isolation level within a session, if you want to use a level other than the default.

You could also set SET TRANSACTION ISOLATION LEVEL within stored procedure body.