Lock a table in SQL Server

Question

Is there a command/SQL query to lock a particular table in MS SQL Server to stop all related transactions using ODBC?

Answer 1

Use the table hints, such as:

SELECT * FROM MyTable WITH (TABLOCK, HOLDLOCK)

See Table Hints in Books Online for more details.

Answer 2

Try taking a look at this:

http://www.mssqlcity.com/Articles/Adm/SQL70Locks.htm