Post reply

When I connect to a database with username and password

  • September 30, 2004 at 1:45 am

    #163216

    How can I check if it is another connection with the same username and password and refuse this second connection.

    Sorry I'm a beginner in T-SQL

  • September 30, 2004 at 11:53 pm

    #524973

    Hey sorin

    You could check in master..sysprocesses for the current list of connections, and use the kill command to drop other connections. This is generally a bad idea though.

    Why do you want to refuse the second connection ?

    Julian Kuiters
    juliankuiters.id.au

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

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