>HI
>
>can anyone think of a way I can warn users of a database that they need to disconnect and then disconnect them. Also leave all users locked out until I let them back in.
>
>This is SQL Server 2005.
>
>Thanks

Untested by me, sounds about right ---

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/d969c05c-c1ba-40fa-b582-d80b333bcd3d/