Hi Frank, Yikes. This is beyond me. I'll wait to discuss this option with the System Admin when he's here next week. Would I do this from the server or each pc that connects via Windows Remote Workstation? Patti
--- On Thu, 6/23/11, Frank Taylor <[email protected]> wrote: From: Frank Taylor <[email protected]> Subject: [RBASE-L] - RE: disconnecting old database connections To: "RBASE-L Mailing List" <[email protected]> Date: Thursday, June 23, 2011, 3:55 PM Patti, Are these local area network session or Terminal User sessions.? In either case here are your options Local Area Connected shares stuck open – On the Server with the Database Shares · Open Computer Management. (right click on My computer and Click Manage) · In the console tree, click Sessions. To disconnect all users, on the Action menu, click Disconnect All Sessions. To disconnect one user, in the details pane, right-click the user name, and then click Close Session. To disconnect multiple users, press the CTRL key while clicking the user names, right-click any user name, and then click Close Session. You can also do this at the command prompt, or create a batch file to do this automatically each night from the command line but you need to do this for each computer in your network, which is easy for a small office, but not recommended for a large office · Open Command Prompt. · net session\\computername/delete If this is a Remote Desktop Connection that is stuck then Open the Terminal Services Manager under Administrative Tools Find the Session that is stuck, right click on it and click Disconnect, then right click again and click reset. You can also do this from the command prompt, after first finding the Session ID that is stuck On the Terminal Server, click Start, and then click Run. Type cmd, and then click OK. Determine the name or ID of the session that you want to disconnect. To do so type query session Once you find the Session ID type tsdiscon SessionID Keep in mind you are forcibly closing open RBase sessions, Not always recommended. Frank Taylor - Information Technology Administrator F.J. O'Hara & Sons, Inc - Araho Transfer Inc. Boston, MA - Rockland, ME - Miami, FL Direct Dial - 617-790-3093 email: [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Patti Jakusz Sent: Thursday, June 23, 2011 10:39 AM To: RBASE-L Mailing List Subject: [RBASE-L] - disconnecting old database connections Hi, We have two users that use windows remote workstation to connect to our database. When these users end their session, the exit the application and logout. But Rbase thinks they are still connected. I noticed that if I click on the "disconnect" menu option, Rbase will show one less user connected. So I know how to fix this problem from now on. But how do I disconnect all these connections that are no longer even ther?. Legacy versions of Rbase had some way to force disconnections. I need to pack the database, since I added a column to a table that has 650,000 rows. (We also have a system administrator who comes in two half days per month and we're a week away from his next work day.) Thanks, Patti
