I’ve never seen this problem before. I went to change the name of a database in SQL Server 2008, but got hit with an error message saying that the db has to be exclusively locked to do this. So obviously someone else is using the database, but I don’t know who. We have a rather large organization spread across the world, so I can’t just walk down the hall and ask who is using it. Is there a way that I can see who is using the database programmatically so that I can contact them to close out?
October 7, 2013 12:19 PM