Preventing object locks - HELP!

[roswald]

All our SQL Server 2000 users are in a Read-Only group named Readers. Is there a command that will prevent any user in that group (Readers), from being granted any Lock on any Object between 3pm and 4pm?
I need to accomplish the following;
1. Any users that are active when my script is launched are prevented from being granted a lock once any locks they may already have on an object is freed.
2. Anyone that logs onto the system between 3pm and 4pm is prevented from being granted any locks.
3. At 4pm all is set back to normal.
At first I wanted to use Net Send to warn active users, kick them off and prevent anyone from logging in for that time period. My problem was that IT will not permit us to use Net Send because we would need to turn on the Messenger service for that to happen.

Please lend me your expertise.
Thanks for your help!

b

 

[mrdenny]

You can set the database to not allow people into the database by setting it into restricted mode.

You could also kill all the users, then remove the group from the database, do your loading (or what ever needs to be done), then add the group back in.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com