SQL open database?

Hi, How can I find out when somebody has an open database on a sql server?
I need to apply a patch but can’t seem to find out who’s logged in.. thanks