Post reply

Disconnect instance or connection of sql server

  • July 20, 2009 at 3:26 am

    #223704

    Hi,

    In sybase we could disconnect the instance (connection) using "syb_quit()" command. Do we have any script available in sql server like sybase ?

    Thanks

    Pras

  • July 20, 2009 at 4:58 am

    #1026854

    In sybase we could disconnect the instance (connection) using "syb_quit()" command. Do we have any script available in sql server like sybase ?

    in sqlserver we have a similar command called kill to close the user connection to the database.

    syntax: kill spid

    ex: kill 58

    you can check out the spid from sp_who2 or running select * from sys.processes table.

    Note: spid between 1 to 50 are used by sqlserver. Dont kill spid's between 1 to 50.

    I would like to know why you want to kill a session? It is not at all recommended.

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • July 20, 2009 at 10:18 pm

    #1027404

    Thanks for your reply.

    I believe Kill function used to kill the process of the instance. I wanted to know how to quit the connection of the instance by script. In sybase 12.5.3 we could end the connection by this script however we couldn't end the connection while the process is running. syb_quit() function is used to disconnect the sql server connection not the process. Hope you understand.

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

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