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 ...


--
HTH,
Vinod Kumar
MCSE, DBA, MCAD
SCT Software Solutions
[url]http://www32.brinkster.com/sqlvinod[/url]


"Frank Dulk" <fdulkbol.com.br> 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?
>
>