How can I restrict my users to stop getting Log in / accessed into my Database by Enterprise Manager or by any other way in SQL Server 2000?
A:
You'll need to provide more details of the scenario you're trying to support, but you can put a database into single user mode to allow one and only one user in (your admin account for example). As part of this, you can force existing connections closed.
Jerry Bullard
2009-09-14 05:38:19