Post reply

Restrict Number of Concurrent Processes?

  • September 16, 2004 at 12:21 pm

    #181866

    Hello,

    MSSQL 2000/SP3

    Is there a method or stored procedure that restricts the number of processes a particular user could use? For example, I would like to set a maximum number of times an account (web or NT) could concurrently connect to the database server or database.

    Many thanks. Jeff

  • September 20, 2004 at 10:43 am

    #523694

    I don't think SQL Server can restrict the number of sessions for a particular user. You can restrict the total user connections by setting the advanced option user Connections.

  • September 20, 2004 at 12:01 pm

    #523705

    There isn't a way to limit by user, only by total connections.

  • September 20, 2004 at 1:53 pm

    #523718

    thanks.

    Many thanks. Jeff

  • September 20, 2004 at 2:25 pm

    #523720

    Jeff,

    You may try to use sysprocesses table which has UID, nt_username and loginame fields if your users are using your application to connect to SQL Server. Your application may query sysprocesses which also has a dbid field and decide if the user may create a connection based on if the process is sysprocesses already exist for the a particular Windows or SQL Server user in a particular database

    Yelena

    Regards,Yelena Varsha

Viewing 5 posts - 1 through 5 (of 5 total)

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