Home Forums SQL Server 2008 SQL Server 2008 - General sql server 2000: how to limit a users session connecting to the database. RE: sql server 2000: how to limit a users session connecting to the database.

  • That's how I would do it.

    Even if SQL Server 2000 had logon triggers, it would not help, as you would have to check for existing sessions, not for new ones.

    -- Gianluca Sartori