1,112
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (