You’re offline. This is a read only version of the page.
1,144
Dear All,
In a Client place, the End Users are accessing the NAV 2009 R2 Database thru Remotely as well as locally.
Idle Session SQL Script is able to kill only Remote users & it does have any effect on local users who are accessing NAV application locally.
What could be the reason ?
Kindly inform me.
Regards,
SB
*This post is locked for comments
SQL Script....
USE MyClientDatabase
DECLARE @EXECSQL varchar(max)
SET @EXECSQL ="SELECT @EXECSQL =@EXECSQL+'KILL' +Convert(varchar,[Connection ID])+';' FROM Session WHERE [Application Name]=................................[Idle Time] >12345
EXEC (@EXECSQL)
Hello, you can drop users from NAV (local or remote) by simply removing them from the [Active Session] table. Use the SELECT statement below to find the Session ID of the user that you want to end the session for. Then use the DELETE statement as set to that Session ID. Do not exclude the WHERE statement when you run the DELETE statement. (The DELETE statement remains commented out until needed):
--DELETE FROM [Active Session] --WHERE [Session ID] = 5753 ------------------------------ SELECT * FROM [Active Session] ORDER BY [User ID] ASC
If you can share the script we will be able to give you an idea. Ideally we can write script to kill the ideal user sessions SQL regardless the locally or remotely.
#1
Sohail Ahmed
2
#1
mmv
2
#1
Amol Salvi
2
Share
Report
All responses (
Answers (
