Very Computer

KenParis schrieb:

Quote:> I'm supporting one of our users remotely and I have very little
> knowledge
> of SQLServer.  She has a series of sequentially run programs which run
> by
> themselves.  They do alot of updating, so I suggested that she put a
> 'LOCK
> TABLE tablename IN EXCLUSIVE MODE' into each program for each table
> being
> used.

> She said it compiled fine but when she runs she gets an error saying
> 'invalid syntax near lock'.

> Any ideas?

> Thanks

Kay Erkmann

Kay,

You can lock a table. Example:
BEGIN TRAN
SELECT * FROM AUTHORS (TABLOCKX HOLDLOCK)
....
COMMIT TRAN

Search in BOL for "TABLOCK", and you find the avaliable optimizer hints.
Note that a pageloch can be escalated to a table lock. This is
configurable... Search for "lock escalation".
--

MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB

Quote:> KenParis schrieb:

> > I'm supporting one of our users remotely and I have very little
> > knowledge
> > of SQLServer.  She has a series of sequentially run programs which run
> > by
> > themselves.  They do alot of updating, so I suggested that she put a
> > 'LOCK
> > TABLE tablename IN EXCLUSIVE MODE' into each program for each table
> > being
> > used.

> > She said it compiled fine but when she runs she gets an error saying
> > 'invalid syntax near lock'.

> > Any ideas?

> > Thanks

>    For my opinion, LOCK table will not be supported by SQL Server. For
> locking a table in exclusive mode use a select count(*) for this table
> with optimizer hint (EXCLUSIVE LOCK).

> Kay Erkmann