Re: How to disconnect a user from SQL Server 2000

KFX
If I understood you correctly you need to identify a username connected to
the database and if he/she does not have 'permissions' to be connected you
want to 'kill' them, am I right?
Take a look at select spid,hostname from master..sysprocesses where
dbid=....







"KFX" <KFX@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:503D6AC2-0675-4567-8B1C-792C1030B9EE@xxxxxxxxxxxxxxxx
Hi,
can anyone help me about disconnecting a specific user from SQL Server
2000?
I tried the KILL command but when I re-run the query the spid show ups
again
with the sp_who command (and of course the data reload it at the terminal
PC...). I need to be able to reject a user manually if I decide that it
mustn't be connected to a database.
Thanks...


.

Relevant Pages

  • RE: Compacting MDB help
    ... I set your code in the Compact Function in the If....Then statement ... (which checks to see if the database size is above a certain limit). ... Only use the Kill command if you are able to recover the data if things go ... Where is the appropriate point to call the Compact Function? ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compacting MDB help
    ... front end database is still running. ... I set your code in the Compact Function in the If....Then statement ... Only use the Kill command if you are able to recover the data if things go ... Where is the appropriate point to call the Compact Function? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Programmatically Dropping databases
    ... you have to kill all user processes that are currently connected to your db ... use sp_who to list all the connections and use the KILL command with SPID ... > How can I drop a database when a user is logged into it? ...
    (microsoft.public.sqlserver.programming)
  • Re: Error trying to kill a database from vb6 program
    ... delete a database (.mdb) with the kill command in vb6. ...
    (comp.lang.basic.visual.misc)
  • Re: Cant take db offline
    ... >I have an ERP system, and I am try to take the db offline to restore, but ... You can then use the KILL command to kill off the spids who are connected. ... you should be able to put the database in db use only. ...
    (microsoft.public.sqlserver.server)