There is a command to lock an entire table LOCK TABLE employees IN EXCLUSIVE MODE NOWAIT; , but haven't tried this from MSSQL. Perhaps through openquery.

Not sure why you need the lock, as it won't prevent querying.