For my opinion, LOCK table will not be supported by SQL Server. ForQuote:> I'm supporting one of our users remotely and I have very little
> of SQLServer. She has a series of sequentially run programs which run
> themselves. They do alot of updating, so I suggested that she put a
> TABLE tablename IN EXCLUSIVE MODE' into each program for each table
> She said it compiled fine but when she runs she gets an error saying
> 'invalid syntax near lock'.
> Any ideas?
locking a table in exclusive mode use a select count(*) for this table
with optimizer hint (EXCLUSIVE LOCK).