I'm going to be working in a SQL Server production environment where they require all manual queries to use WITH (NOLOCK). To examine tables they usually just execute a short query with the NOLOCK hint. I prefer using something such as Database Browser but can not unless it internally uses the NOLOCK. Can someone tell me absolutely if it does or does not? If not, can a configurable option be added to allow such operation?
- Ed Cox