How to limit number of connections for a user

Is there a way to limit a user's number of connections?
I'm asking because I have a user who keeps more than 50 query windows in
query analyzer.
Thanks!At the client side no...
on the server side you could write a scrip that periodically looks at
master..sysprocesses and issues KILL commands for connections that you want
to close.
But there is no way to set a threshold that say 'this user has 10
connections already so don't allow number 11'. You'd have to kill number 11
after it happens...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Michael" <michael.rodriguez@.loanperformance.com> wrote in message
news:u3OxQqlxDHA.3408@.tk2msftngp13.phx.gbl...
> Is there a way to limit a user's number of connections?
> I'm asking because I have a user who keeps more than 50 query windows in
> query analyzer.
> Thanks!
>|||Thanks for the reply Brian. I really appreciate it.
Unfortunately I'm looking for something better.
Maybe in future release of SQL server, they'll add that in there.
Thanks again!
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:OarcT%23lxDHA.3224@.tk2msftngp13.phx.gbl...
> At the client side no...
> on the server side you could write a scrip that periodically looks at
> master..sysprocesses and issues KILL commands for connections that you
want
> to close.
> But there is no way to set a threshold that say 'this user has 10
> connections already so don't allow number 11'. You'd have to kill number
11
> after it happens...
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Michael" <michael.rodriguez@.loanperformance.com> wrote in message
> news:u3OxQqlxDHA.3408@.tk2msftngp13.phx.gbl...
> > Is there a way to limit a user's number of connections?
> >
> > I'm asking because I have a user who keeps more than 50 query windows in
> > query analyzer.
> >
> > Thanks!
> >
> >
>|||Hi Michael,
Thank you for using MSDN Newsgroup!
Thank you for your feedback! I am regret that there is not a easier way to
meet your request in SQL Server 2000. However, the products of Microsoft is
always keep up with the current application and forsee the new application
in different fields. There are many new exciting and powerful features in
our new generation SQL Server-Yukon, which are based on our study of the
new application of the Database systems. You can refer the information of
Yukon at:
http://www.microsoft.com/sql/yukon/productinfo/default.asp
You feedback is helpful for our developer to produce the best products and
satisfy our customers include you and others using products of Microsoft.
Thank you very much! Merry Christmas and Happy New Year!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.