You can manually escalate the lock level to TABLOCK by specifying the
lock level after the object queried for.

HTH, Jens Suessmeyer.

If you truly are going to drop the original table, then the standard
TABLOCKX won't do it. Consider using an application lock, though the rest
of the application would have to be modified to respect the lock.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
[quoted text, click to view]
I have a table that I need to do a whole lot of manipulations to in a
stored procedure, including copying a whole bunch of it elsewhere,
dropping the original table and then recreating it.

The process takes about three minutes. During this time, I want to stop
any other users attempting to access that table.

Is there a simple way of manually ensuring that the table is locked?

I have a table that I need to do a whole lot of manipulations to in a
stored procedure, including copying a whole bunch of it elsewhere,
dropping the original table and then recreating it.

The process takes about three minutes. During this time, I want to stop
any other users attempting to access that table.