Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Listen
Starting Member
44 Posts |
 Posted - 2004-11-05 : 04:01:56
|
| Is there a command that disconnects the user connection in Stored Procedures? I'm asking this because we have been experiencing slowness in our server. I use MS Visual Basic 6 as my front-end. Last week, I discovered that some of my PUBLIC FUNCTIONS do not have SET CN=NOTHING after I executed a stored procedure, thinking that this contributes slowness in the server becuase the user connection is still in the server. But, after I supplied SET CN=NOTHING to all Public Functions, nothing has changed. Still, the server is very slow, though my stored procedures are very simple.Please help me on my problem. This has been my burdeng since year 2002.Many thanks. |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-05 : 04:08:54
|
| not sure what you mean, but you can issue a Kill <spid> command to users you want to disconnect.--------------------keeping it simple... |
 |
|
|
Listen
Starting Member
44 Posts |
Posted - 2004-11-05 : 04:24:50
|
| What if I use KILL and the user is updating records, will the update process discontinue?Thank you |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-05 : 05:15:12
|
| it will disconnect the user and process is cancelled.--------------------keeping it simple... |
|
|
|
|
|
|
Disconnect Command