July 20, 2009 at 3:26 am
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
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
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