How do I see who is currently in a database on the network, and if possible how do I kick them out?

Hi again. With the database I'm currently developing I occasionally need users to stop using the database so I can make amendments to data and structure to which I usually send out a pop-up requesting everybody gets out of it.

However, like most users they tend to think "I'll do it after I finish this page of records" and at the moment I'm powerless to do anything bar go all over the building and look at the screens (for some reason Remote Desktop isn't working properly for all machines) and give the culprit a roasting while the other users who have complied get irritated through no fault of my own. And guess who takes the flak... IT department.

So at the very least I'd like a means to see who is currently using the database so I can go straight to them and if required I can defend IT by saying "Joe Blogs was the reason, flame him". As a bonus a remote way of booting them off would be splendid.

Btw, if PsFile is suggested I might need someone to explain to me why it isn't working since I think this utility would do the above job but for some reason despite it saying it's closed the file it blatantly hasn't.

I'm offering 500 points since this is pretty detrimental to the speed of the project, and a grade A if you can help with the second part.

Cheers! :D

Who is Participating?
Keith AlabasterEnterprise ArchitectCommented:
Just for info,

1. Dameware ( acts in the same way as PC Anywhere ie you take the machine over as if you were at the box. RDP makes a session to the box.
2. dameware has a self installer; rdp needs to the services to be running in advance (either remote desktop enabled or running TS on 2000)
Hi chromenewt,

i wont suggest psFile but ill send an option down a similar route :)

also have you trialled with the inbuilt windows tool - computer management?

right click my computer and select manage - under shared folders you can not only see who is logged on but you can see what files are being opened. computer management also lets you boot people off but in your DB environment i would be careful playing with that!


when you say remote desktop doesnt work... is it enabled on all xp machine??
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

chromenewtAuthor Commented:
As far as I'm told all the machines have had remote desktop enabled, and as far as I can tell when I look they all appear to have it working except I can't seem to connect except for a handful.

I've had a go with the tools you mentioned but I suddenly thought of a problem; the methods you describe require me to be on the machine the file is on yet the file I'm working on is on the server in a locked room, not my PC I'm working on. I'll have a quick go with remote desktop again but it probably won't work.
computer management you can do from any machine as you can connect to another computer - right click

ps logged on will run from the server
chromenewtAuthor Commented:
I managed a completely bizarre solution!

I'm using something called Dameware Mini Remote Control which lts me view the users PCs where for some reason Remote Desktop wouldn't. Can you thin kof a reason why this would happen?
ah i have heard about dameware before but never trialled - it doesnt run on the rdp protocol i dont think, so its not restricted in the same way
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.