Hi there,

I want to run a SELECT that has a WITH clause of (XLOCK).

Is there any way to specifiy this or do I need to use a sp or view?

Cheers, Ian.

You can add it with a bit of work in v2.6 to a derived class of the Sqlserver DQE, it's not build in by default. See this post: http://www.llblgen.com/TinyForum/GotoMessage.aspx?MessageID=78587&ThreadID=14111

I just wrapped one of the tables being joined to in my query with a view and did a simple 'SELECT * FROM tbl... WITH (XLOCK)'. Seems to work ok because all of the rows in the query are joining to this view.

It only seems to lock the view though. The underlying table I can SELECT from even when the view is being read!

You'd better try Frans suggestion (a derived class of the Sqlserver DQE).

Why had I better try the suggestion? Is what I've done not going to work?

Even though I said the underlying table was not being locked, I only need the rows retrieved with XLOCK for this one query. Just locking this one table with a view works for this one query.

Even though I said the underlying table was not being locked, I only need the rows retrieved with XLOCK for this one query. Just locking this one table with a view works for this one query

Ok, I thought you had a problem with not locking the table.