Post reply

How to limit the number of users on a db?

  • January 13, 2006 at 9:15 am

    #89228

    I have a requirement to limit the number of users to 20 on a particular db. Is there any way to achieve this? Orginally, I intended to put a trigger on the sysprocesses table but I believe you can't put a trigger on a system table.

    thanks in advance.

  • January 13, 2006 at 9:32 am

    #614680

    I assume that you want to limit the number of user connections and not users?  I do not believe that this can be done.  Can you explain a little more on what this requirement is trying to accomplish?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • January 13, 2006 at 9:32 am

    #614679

    This thread has some suggestions: http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=1666

    Greg

    Greg

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply