Anyone know the equiv Microsoft command that does table locking such as below?
This code snippet is from Sybase and I need to convert it to Microsoft SQL2k - SP3.

/* Lock the tables that will be transferred TO DW.
* The locks will be removed when this stored procedure
* is exited. "mode wait" means wait patiently
* until the table can be locked. */

lock table CPLACT in exclusive mode wait
lock table CPLSUP in exclusive mode wait
lock table CNSACT in exclusive mode wait
lock table CNSSUP in exclusive mode wait

--
___________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200

use tablockx for exclusive table lock