HomeForum
Welcome, Guest

Does Browser use NOLOCK?
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Does Browser use NOLOCK?

Does Browser use NOLOCK? 3 years, 3 months ago #581

  • eecoxjr
  • OFFLINE
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
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

Re:Does Browser use NOLOCK? 3 years, 3 months ago #582

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
It does not use any hints
Just plain select * from table

Mark
  • Page:
  • 1
Time to create page: 0.14 seconds

Testimonials

Development team listens to it's customers and implements new features in days sometimes hours.

Paul Gibb,
MPS

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top