There is no buildin feature that you can capitalize on ... But you can schedule a job that runs over a specified interval and disconnects the extra connections ... This is one option that I can think ...

Vinod Kumar
SCT Software Solutions

"Frank Dulk" <> wrote in message news:u8HuGhiQDHA.1560TK2MSFTNGP12.phx.gbl...
> somebody knows as limiting the number of connections
> of an user in SQL Server 2000? Former. I want no other user to enter with
> the same username and an user's password that it is log. Is it possible to
> do that?