'Forgot WITH (READUNCOMMITTED) in SQL

At my company I was advised to always run SQL queries as follows:

SELECT col1, col2
FROM table WITH (READUNCOMMITTED)
WHERE table.id = my_id;

It is a production database which is used by other applications and I only have read access. However I issued a query like the following:

SELECT col1, col2 FROM table;

Is it possible that I corrupted the database by locking parts of it due to the missing WITH (READUNCOMMITTED)? I stopped the query before it could finish.

sqlsql-serverread-uncommitted


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions